explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AyjZ

Settings
# exclusive inclusive rows x rows loops node
1. 3,203.023 8,601.767 ↑ 6.8 46 1

Index Scan using idx_workflow_nom_batch on gep.workflow (cost=1.42..83,487,354.78 rows=311 width=4) (actual time=1,869.241..8,601.767 rows=46 loops=1)

  • Output: workflow.workflow_id
  • Index Cond: ((workflow.nom_batch)::text = 'GIA_MBE_ModificationSalaireDegreGIABatch_CPEV_2019-04-10_125026846_t1'::text)
  • Filter: (NOT (SubPlan 1))
2.          

SubPlan (forIndex Scan)

3. 3,747.225 5,398.744 ↑ 1.1 965,482 46

Materialize (cost=0.86..265,451.87 rows=1,023,229 width=4) (actual time=0.021..117.364 rows=965,482 loops=46)

  • Output: a.workflow_id
4. 986.771 1,651.519 ↑ 1.1 965,482 1

Merge Join (cost=0.86..256,338.73 rows=1,023,229 width=4) (actual time=0.722..1,651.519 rows=965,482 loops=1)

  • Output: a.workflow_id
  • Merge Cond: (((a.type_liberation)::text = (b.type_liberation)::text) AND (a.workflow_id = b.workflow_id))
  • -> Index Only Scan using gep_workflow_process_type_liberation_workflow_id on gep.workflow_process b (cost=0.43..170922.08 rows=5593674 width=9) (actual time=0.046..263.965 rows=1
5. 664.748 664.748 ↑ 1.0 5,022,960 1

Index Only Scan using gep_workflow_type_liberation_workflow_id on gep.workflow a (cost=0.43..154,654.75 rows=5,022,960 width=9) (actual time=0.672..664.748 rows=5,022,960 loops=1)

  • Output: a.type_liberation, a.workflow_id
  • Heap Fetches: 2765
  • Output: b.type_liberation, b.workflow_id
  • Heap Fetches: 72
Planning time : 0.676 ms
Execution time : 8,604.953 ms