explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zikg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=1,403,905.82..1,407,132.48 rows=1 width=551) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,403,905.68..1,407,132.29 rows=1 width=551) (actual rows= loops=)

  • Hash Cond: (stock6_.ref_pdl = pds0_.ref_externe)
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,403,877.11..1,405,235.68 rows=135,857 width=11) (actual rows= loops=)

  • Group Key: stock6_.ref_pdl
4. 0.000 0.000 ↓ 0.0

Seq Scan on stock stock6_ (cost=0.00..1,329,396.00 rows=29,792,441 width=11) (actual rows= loops=)

  • Filter: (((date_fin_validite IS NULL) OR (date_fin_validite > '2020-02-10 18:15:00.00926'::timestamp without time zone)) AND ((date_debut_validite IS NULL) OR (date_debut_validite < '2020-02-10 18:15:00.00926'::timestamp without time zone)))
5. 0.000 0.000 ↓ 0.0

Hash (cost=28.56..28.56 rows=1 width=562) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19.48..28.56 rows=1 width=562) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19.21..28.09 rows=1 width=391) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=18.94..27.79 rows=1 width=220) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

HashAggregate (cost=18.51..18.52 rows=1 width=11) (actual rows= loops=)

  • Group Key: conditions4_.ref_pdl
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..18.51 rows=1 width=11) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using conditions_de_service_code_specialite_hbe_ind_tracabilite_3d_id on conditions_de_service conditions4_ (cost=0.43..9.25 rows=1 width=11) (actual rows= loops=)

  • Index Cond: ((code_specialite_hbe = '1'::text) AND (ind_tracabilite_3d = 1))
  • Filter: (code_service = ANY ('{11,22,28}'::text[]))
12. 0.000 0.000 ↓ 0.0

Index Only Scan using uq_pdl_ref_externe on pds pds5_ (cost=0.43..9.25 rows=1 width=11) (actual rows= loops=)

  • Index Cond: (ref_externe = conditions4_.ref_pdl)
  • Index Cond: (ref_externe = conditions4_.ref_pdl)
13. 0.000 0.000 ↓ 0.0

Index Scan using uq_pdl_ref_externe on pds pds0_ (cost=0.43..9.25 rows=1 width=209) (actual rows= loops=)

  • Index Cond: (ref_externe = conditions4_.ref_pdl)
  • Filter: (actif AND ((date_sortie IS NULL) OR (date_sortie > '2020-02-10 18:15:00.00926'::timestamp without time zone)))
14. 0.000 0.000 ↓ 0.0

Index Scan using uq_centre_ref_externe on centre centre1_ (cost=0.27..0.29 rows=1 width=171) (actual rows= loops=)

  • Index Cond: (ref_externe = pds0_.ref_centre)
15. 0.000 0.000 ↓ 0.0

Index Scan using uq_centre_ref_externe on centre centre2_ (cost=0.27..0.46 rows=1 width=171) (actual rows= loops=)

  • Index Cond: (ref_externe = centre1_.code_exploitation_usine)
16. 0.000 0.000 ↓ 0.0

Index Scan using replica_synchro_ref_object_idx on replica_synchro pdssynchro3_ (cost=0.14..0.17 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (ref_object = pds0_.ref_externe)
  • Filter: ((type = ANY ('{CREATE,UPDATE}'::text[])) AND (replica_type = 'PDS'::text))