Tagged Questions
2
votes
2answers
748 views
Understanding time format of the EXPLAIN command - Postgres
When I run the EXPLAIN ANALYZE command on a given query, I'm having a difficult time interpreting the outputted time value. For example (actual time=8163.890..8163.893). Do the internal decimals ...
1
vote
1answer
331 views
What does HSJOIN mean in an Explain Plan?
I have the following EXPLAIN PLAN results from a query on my DB2 database.
0 SELECT STATEMENT ( Estimated Costs = 5.928E+02 [timerons] )
1 RETURN
2 HSJOIN
3 [O] ...