explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oboU

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 12.723 ↑ 1.2 6 1

Sort (cost=1,181.13..1,181.15 rows=7 width=49) (actual time=12.721..12.723 rows=6 loops=1)

  • Sort Key: (random())
  • Sort Method: quicksort Memory: 25kB
2. 0.012 12.711 ↑ 1.2 6 1

HashAggregate (cost=1,180.93..1,181.03 rows=7 width=49) (actual time=12.709..12.711 rows=6 loops=1)

  • Group Key: queue.queue_guid
3. 12.686 12.699 ↑ 748.4 18 1

Seq Scan on queue (cost=1.42..1,147.25 rows=13,472 width=37) (actual time=0.033..12.699 rows=18 loops=1)

  • Filter: ((status = ANY ('{ready,locked-sequential}'::text[])) AND (NOT (hashed SubPlan 1)) AND ((tag)::text = 'transmission'::text))
  • Rows Removed by Filter: 29,821
4.          

SubPlan (for Seq Scan)

5. 0.013 0.013 ↓ 1.1 29 1

Seq Scan on meta (cost=0.00..1.35 rows=26 width=37) (actual time=0.003..0.013 rows=29 loops=1)

  • Filter: (NOT paused)
  • Rows Removed by Filter: 10
Planning time : 0.203 ms
Execution time : 12.761 ms