explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d422M : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.184 0.203 ↓ 0.0 0 1

Sort (cost=95.03..97.50 rows=990 width=146) (actual time=0.202..0.203 rows=0 loops=1)

  • Sort Key: batch_search.batch_date DESC, batch_search_query.query_number
  • Sort Method: quicksort Memory: 25kB
2. 0.002 0.019 ↓ 0.0 0 1

Hash Join (cost=23.25..45.77 rows=990 width=146) (actual time=0.019..0.019 rows=0 loops=1)

  • Hash Cond: (batch_search_query.search_uuid = batch_search.uuid)
3. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on batch_search_query (cost=0.00..19.90 rows=990 width=54) (actual time=0.017..0.017 rows=0 loops=1)

4. 0.000 0.000 ↓ 0.0 0

Hash (cost=16.62..16.62 rows=530 width=121) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Seq Scan on batch_search (cost=0.00..16.62 rows=530 width=121) (never executed)

  • Filter: ((state)::text = 'QUEUED'::text)
Planning time : 18.076 ms
Execution time : 0.943 ms