explain.depesz.com

PostgreSQL's explain analyze made readable

Result: omz

Settings
# exclusive inclusive rows x rows loops node
1. 8,716.165 97,550.930 ↑ 30.9 3,576,879 1

Hash Join (cost=2,626,931.54..6,917,094.74 rows=110,469,416 width=4) (actual time=88,372.558..97,550.930 rows=3,576,879 loops=1)

  • Hash Cond: (cte.id = scheduling_flownode.target_object_id)
2.          

CTE cte

3. 239.673 262.703 ↓ 1.0 441,128 1

Bitmap Heap Scan on xact_message (cost=10,572.27..123,341.21 rows=421,153 width=4) (actual time=25.561..262.703 rows=441,128 loops=1)

  • Recheck Cond: ((templatelanguage_id = ANY ('{17,18,19,20,21,22,23,24}'::integer[])) AND (state = 4))
  • Heap Blocks: exact=16581
4. 23.030 23.030 ↓ 1.0 441,128 1

Bitmap Index Scan on "sendon-template-state" (cost=0.00..10,466.98 rows=421,153 width=0) (actual time=23.030..23.030 rows=441,128 loops=1)

  • Index Cond: ((templatelanguage_id = ANY ('{17,18,19,20,21,22,23,24}'::integer[])) AND (state = 4))
5. 512.427 512.427 ↓ 1.0 441,128 1

CTE Scan on cte (cost=0.00..8,423.06 rows=421,153 width=4) (actual time=25.565..512.427 rows=441,128 loops=1)

6. 18,285.796 88,322.338 ↑ 1.0 42,815,347 1

Hash (cost=1,801,150.48..1,801,150.48 rows=42,815,348 width=8) (actual time=88,322.338..88,322.338 rows=42,815,347 loops=1)

  • Buckets: 131072 Batches: 1024 Memory Usage: 2663kB
7. 70,036.542 70,036.542 ↑ 1.0 42,815,347 1

Seq Scan on scheduling_flownode (cost=0.00..1,801,150.48 rows=42,815,348 width=8) (actual time=0.019..70,036.542 rows=42,815,347 loops=1)

Planning time : 0.963 ms
Execution time : 98,219.917 ms