explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2vXv

Settings
# exclusive inclusive rows x rows loops node
1. 179,141.279 179,153.607 ↓ 1.0 22,464 1

Nested Loop (cost=4.83..17,409.10 rows=22,320 width=252) (actual time=17.333..179,153.607 rows=22,464 loops=1)

2. 4.188 6.088 ↓ 1.0 1,248 1

Hash Join (cost=4.83..51.85 rows=1,240 width=34) (actual time=0.482..6.088 rows=1,248 loops=1)

  • Hash Cond: (story.batch_id = batch.batch_id)
3. 1.856 1.856 ↑ 1.0 1,258 1

Seq Scan on story (cost=0.00..43.60 rows=1,260 width=32) (actual time=0.413..1.856 rows=1,258 loops=1)

4. 0.020 0.044 ↓ 1.0 128 1

Hash (cost=3.26..3.26 rows=126 width=6) (actual time=0.044..0.044 rows=128 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
5. 0.024 0.024 ↓ 1.0 128 1

Seq Scan on batch (cost=0.00..3.26 rows=126 width=6) (actual time=0.007..0.024 rows=128 loops=1)

6. 5.841 6.240 ↑ 1.0 18 1,248

Materialize (cost=0.00..3.49 rows=18 width=28) (actual time=0.001..0.005 rows=18 loops=1,248)

7. 0.399 0.399 ↑ 1.0 18 1

Seq Scan on all_sites (cost=0.00..3.40 rows=18 width=28) (actual time=0.360..0.399 rows=18 loops=1)

  • Filter: (status = 'ACTIVE'::text)
  • Rows Removed by Filter: 94
Planning time : 12.435 ms