explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c7HO

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

Gather (cost=1,000.85..7,376,287,399.25 rows=1,246,554 width=339) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=0.85..7,376,161,743.85 rows=519,398 width=339) (actual rows= loops=)

  • Merge Cond: (sica_tag.id_evt = tag_estados_evt.estado_id_evt)
3. 0.000 0.000 ↓ 0.0

Parallel Index Scan using id_evento on sica_tag (cost=0.43..81,211.29 rows=519,398 width=307) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using tag_estados_evt_pkey on tag_estados_evt (cost=0.42..11,092.23 rows=353,054 width=10) (actual rows= loops=)

5.          

SubPlan (forMerge Left Join)

6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..8,584.81 rows=353,054 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on tag_estados_evt tag_estados_evt_1 (cost=0.00..5,439.54 rows=353,054 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..8,584.81 rows=353,054 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on tag_estados_evt tag_estados_evt_2 (cost=0.00..5,439.54 rows=353,054 width=4) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..8,584.81 rows=353,054 width=4) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on tag_estados_evt tag_estados_evt_3 (cost=0.00..5,439.54 rows=353,054 width=4) (actual rows= loops=)