explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lFRt

Settings

Optimization(s) for this plan:

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

Update on t_evenement tt (cost=1.80..89,226,831,903.77 rows=916,587 width=193) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on t_evenement tt (cost=1.80..89,226,831,903.77 rows=916,587 width=193) (actual rows= loops=)

  • Filter: ((etat_apres IS NOT NULL) AND (NOT (SubPlan 1)))
3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=1.80..93,182.26 rows=1,666,522 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=1.80..78,339.65 rows=1,666,522 width=8) (actual rows= loops=)

  • Hash Cond: (te.etat_apres = (pg_enum.enumlabel)::enum_demande_etat)
6. 0.000 0.000 ↓ 0.0

Seq Scan on t_evenement te (cost=0.00..50,777.74 rows=1,833,174 width=12) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=1.68..1.68 rows=10 width=64) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on pg_enum (cost=0.00..1.68 rows=10 width=64) (actual rows= loops=)

  • Filter: (enumtypid = '17128'::oid)