explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LALI

Settings
# exclusive inclusive rows x rows loops node
1. 22.785 223.287 ↓ 1.1 11,551 1

Nested Loop Left Join (cost=3,307.39..38,257.19 rows=10,670 width=104) (actual time=70.583..223.287 rows=11,551 loops=1)

2. 8.505 119.645 ↓ 1.1 11,551 1

Nested Loop Left Join (cost=3,307.31..10,903.17 rows=10,670 width=434) (actual time=70.564..119.645 rows=11,551 loops=1)

  • Join Filter: false
3. 23.220 111.140 ↓ 1.1 11,551 1

Hash Left Join (cost=3,307.31..10,796.47 rows=10,670 width=402) (actual time=70.560..111.140 rows=11,551 loops=1)

  • Hash Cond: (event.parent_path = parent_dir.path)
4. 49.879 49.879 ↓ 1.1 11,551 1

Seq Scan on event (cost=0.00..7,374.50 rows=10,613 width=394) (actual time=33.445..49.879 rows=11,551 loops=1)

  • Filter: ((seq_num >= '149019'::bigint) AND (seq_num <= '162519'::bigint) AND ((type)::integer <> 16384) AND (event_type <> 'REMOVED'::text) AND (volume_id = 578))
  • Rows Removed by Filter: 150,969
5. 16.478 38.041 ↓ 1.0 43,530 1

Hash (cost=2,860.15..2,860.15 rows=42,586 width=54) (actual time=36.822..38.041 rows=43,530 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 4,194kB
6. 21.563 21.563 ↓ 1.0 43,530 1

Seq Scan on dir_current_vol_578 parent_dir (cost=0.00..2,860.15 rows=42,586 width=54) (actual time=0.009..21.563 rows=43,530 loops=1)

  • Filter: (volume_id = 578)
7. 0.000 0.000 ↓ 0.0 0 11,551

Result (cost=0.00..0.00 rows=0 width=32) (actual time=0.000..0.000 rows=0 loops=11,551)

  • One-Time Filter: false
8. 80.857 80.857 ↓ 0.0 0 11,551

Index Scan using file_current_vol_578_volume_id_parent_id_name_key on file_current_vol_578 file (cost=0.08..2.55 rows=1 width=48) (actual time=0.007..0.007 rows=0 loops=11,551)

  • Index Cond: ((volume_id = 578) AND (parent_id = parent_dir.id) AND (name = event.name))