explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yC4R

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

Sort (cost=204,139.11..204,142.86 rows=1,498 width=154) (actual time=497.886..497.886 rows=0 loops=1)

  • Sort Key: (COALESCE(l.last_update, l.creato_il)) DESC
  • Sort Method: quicksort Memory: 17kB
2. 9.188 502.826 ↓ 0.0 0 1

Gather (cost=1,005.25..204,060.10 rows=1,498 width=154) (actual time=497.878..502.826 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.001 493.638 ↓ 0.0 0 3

Nested Loop Left Join (cost=5.25..202,905.93 rows=624 width=154) (actual time=493.638..493.638 rows=0 loops=3)

4. 0.002 493.637 ↓ 0.0 0 3

Hash Left Join (cost=4.83..197,855.27 rows=624 width=95) (actual time=493.637..493.637 rows=0 loops=3)

  • Hash Cond: (l.id_tipo_archiviazione = t.id)
5. 493.635 493.635 ↓ 0.0 0 3

Parallel Seq Scan on t_log l (cost=0.00..197,841.86 rows=624 width=67) (actual time=493.635..493.635 rows=0 loops=3)

  • Filter: ((id_tipo_archiviazione = 148) AND ((id_tipo = 1) OR (id_tipo = 3) OR (id_tipo = 4) OR (id_tipo = 5) OR (id_tipo = 6) OR (id_tipo = 7)))
  • Rows Removed by Filter: 599690
6. 0.000 0.000 ↓ 0.0 0

Hash (cost=4.81..4.81 rows=1 width=36) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Seq Scan on t_tipi_archiviazione t (cost=0.00..4.81 rows=1 width=36) (never executed)

  • Filter: (id = 148)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using t_archivi_pkey on t_archivi a (cost=0.43..8.08 rows=1 width=73) (never executed)

  • Index Cond: (l.id_archivio = id)
Planning time : 0.583 ms
Execution time : 502.909 ms