explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oQix

Settings
# exclusive inclusive rows x rows loops node
1. 180,460.746 180,472.066 ↓ 1.0 22,464 1

Nested Loop (cost=4.83..17,409.10 rows=22,320 width=252) (actual time=10.681..180,472.066 rows=22,464 loops=1)

2. 4.068 5.080 ↓ 1.0 1,248 1

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

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

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

4. 0.018 0.042 ↓ 1.0 128 1

Hash (cost=3.26..3.26 rows=126 width=6) (actual time=0.042..0.042 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. 6.212 6.240 ↑ 1.0 18 1,248

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

7. 0.028 0.028 ↑ 1.0 18 1

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

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