explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W4Bs : OLD EXPLAIN

Settings
# exclusive inclusive rows x rows loops node
1. 195,466.934 195,479.824 ↑ 5.3 22,608 1

Nested Loop (cost=5.03..93,131.54 rows=119,700 width=252) (actual time=8.624..195,479.824 rows=22,608 loops=1)

2. 4.032 6.610 ↑ 1.0 1,256 1

Hash Join (cost=4.88..51.90 rows=1,260 width=34) (actual time=0.056..6.610 rows=1,256 loops=1)

  • Hash Cond: (story.batch_id = batch.batch_id)
3. 2.538 2.538 ↓ 1.0 1,266 1

Seq Scan on story (cost=0.00..43.60 rows=1,260 width=32) (actual time=0.008..2.538 rows=1,266 loops=1)

4. 0.017 0.040 ↑ 1.0 128 1

Hash (cost=3.28..3.28 rows=128 width=6) (actual time=0.040..0.040 rows=128 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
5. 0.023 0.023 ↑ 1.0 128 1

Seq Scan on batch (cost=0.00..3.28 rows=128 width=6) (actual time=0.006..0.023 rows=128 loops=1)

6. 6.251 6.280 ↑ 5.3 18 1,256

Materialize (cost=0.15..13.13 rows=95 width=28) (actual time=0.000..0.005 rows=18 loops=1,256)

7. 0.029 0.029 ↑ 5.3 18 1

Index Scan using all_sites_status_idx on all_sites (cost=0.15..12.66 rows=95 width=28) (actual time=0.007..0.029 rows=18 loops=1)

  • Index Cond: (status = 'ACTIVE'::text)
Planning time : 0.779 ms