explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BOhy

Settings
# exclusive inclusive rows x rows loops node
1. 0.172 23,483.937 ↑ 6.8 46 1

Sort (cost=417,990,890.04..417,990,890.82 rows=311 width=4) (actual time=23,483.933..23,483.937 rows=46 loops=1)

  • Output: workflow.workflow_id
  • Sort Key: workflow.workflow_id
  • Sort Method: quicksort Memory: 27kB
2. 3,297.512 23,483.765 ↑ 6.8 46 1

Bitmap Heap Scan on gep.workflow (cost=260,949.26..417,990,877.16 rows=311 width=4) (actual time=16,581.172..23,483.765 rows=46 loops=1)

  • Output: workflow.workflow_id
  • Recheck Cond: ((workflow.nom_batch)::text = 'GIA_MBE_ModificationSalaireDegreGIABatch_CPEV_2019-04-10_125026846_t1'::text)
  • Filter: (NOT (SubPlan 1))
  • Heap Blocks: exact=17
3. 0.027 0.027 ↑ 9.6 65 1

Bitmap Index Scan on idx_workflow_nom_batch (cost=0.00..29.23 rows=623 width=0) (actual time=0.027..0.027 rows=65 loops=1)

  • Index Cond: ((workflow.nom_batch)::text = 'GIA_MBE_ModificationSalaireDegreGIABatch_CPEV_2019-04-10_125026846_t1'::text)
4.          

SubPlan (forBitmap Heap Scan)

5. 3,837.874 20,186.226 ↑ 1.1 965,482 46

Materialize (cost=260,919.95..1,599,381.36 rows=1,023,229 width=4) (actual time=42.611..438.831 rows=965,482 loops=46)

  • Output: a.workflow_id
6. 3,050.724 16,348.352 ↑ 1.1 965,482 1

Hash Join (cost=260,919.95..1,590,268.22 rows=1,023,229 width=4) (actual time=1,959.909..16,348.352 rows=965,482 loops=1)

  • Output: a.workflow_id
  • Hash Cond: ((b.workflow_id = a.workflow_id) AND ((b.type_liberation)::text = (a.type_liberation)::text))
7. 11,338.663 11,338.663 ↑ 1.0 5,593,672 1

Seq Scan on gep.workflow_process b (cost=0.00..1,142,073.72 rows=5,593,672 width=9) (actual time=0.040..11,338.663 rows=5,593,672 loops=1)

  • Output: b.workflow_id, b.type_liberation
8. 943.777 1,958.965 ↑ 1.0 5,022,958 1

Hash (cost=161,048.58..161,048.58 rows=5,022,958 width=9) (actual time=1,958.965..1,958.965 rows=5,022,958 loops=1)

  • Output: a.workflow_id, a.type_liberation
  • Buckets: 524288 Batches: 32 Memory Usage: 10379kB
9. 1,015.188 1,015.188 ↑ 1.0 5,022,958 1

Seq Scan on gep.workflow a (cost=0.00..161,048.58 rows=5,022,958 width=9) (actual time=0.024..1,015.188 rows=5,022,958 loops=1)

  • Output: a.workflow_id, a.type_liberation