explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7PAG

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 19.924 ↑ 793.8 18 1

Unique (cost=2,232.91..2,375.79 rows=14,288 width=49) (actual time=19.898..19.924 rows=18 loops=1)

2. 0.031 19.904 ↑ 793.8 18 1

Sort (cost=2,232.91..2,268.63 rows=14,288 width=49) (actual time=19.896..19.904 rows=18 loops=1)

  • Sort Key: (random()), queue.queue_guid, (hashtext(queue.queue_guid))
  • Sort Method: quicksort Memory: 27kB
3. 19.851 19.873 ↑ 793.8 18 1

Seq Scan on queue (cost=1.42..1,246.86 rows=14,288 width=49) (actual time=0.053..19.873 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,806
4.          

SubPlan (for Seq Scan)

5. 0.022 0.022 ↓ 1.1 29 1

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

  • Filter: (NOT paused)
  • Rows Removed by Filter: 10
Planning time : 0.580 ms
Execution time : 19.972 ms