explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XD6Q

Settings
# exclusive inclusive rows x rows loops node
1. 188,732.287 188,745.891 ↑ 5.2 22,464 1

Nested Loop (cost=4.99..91,654.25 rows=117,800 width=252) (actual time=14.868..188,745.891 rows=22,464 loops=1)

2. 4.206 7.364 ↓ 1.0 1,248 1

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

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

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

4. 0.020 0.040 ↓ 1.0 128 1

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

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

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

6. 6.207 6.240 ↑ 5.3 18 1,248

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

7. 0.033 0.033 ↑ 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.010..0.033 rows=18 loops=1)

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