explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qpYWF

Settings
# exclusive inclusive rows x rows loops node
1. 246.323 3,103.299 ↓ 1.6 252,171 1

Hash Join (cost=115,920.82..170,368.80 rows=156,402 width=32) (actual time=1,933.333..3,103.299 rows=252,171 loops=1)

  • Hash Cond: (events_venues.venues_profiles_id = venues_profiles.id)
2. 618.724 2,344.120 ↓ 1.6 252,171 1

Hash Join (cost=82,720.95..132,507.40 rows=156,402 width=12) (actual time=1,420.346..2,344.120 rows=252,171 loops=1)

  • Hash Cond: (events.id = events_venues.events_id)
3. 305.208 305.208 ↑ 1.0 1,058,835 1

Seq Scan on events (cost=0.00..35,214.35 rows=1,058,835 width=8) (actual time=0.014..305.208 rows=1,058,835 loops=1)

4. 68.330 1,420.188 ↓ 1.6 252,171 1

Hash (cost=80,001.93..80,001.93 rows=156,402 width=12) (actual time=1,420.188..1,420.188 rows=252,171 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 3748kB
5. 630.273 1,351.858 ↓ 1.6 252,171 1

Hash Join (cost=48,334.77..80,001.93 rows=156,402 width=12) (actual time=512.332..1,351.858 rows=252,171 loops=1)

  • Hash Cond: (events_venues.events_id = claims.events_id)
6. 209.457 209.457 ↑ 1.0 1,059,210 1

Seq Scan on events_venues (cost=0.00..17,244.10 rows=1,059,210 width=8) (actual time=0.009..209.457 rows=1,059,210 loops=1)

7. 80.335 512.128 ↓ 1.6 252,171 1

Hash (cost=45,768.74..45,768.74 rows=156,402 width=4) (actual time=512.128..512.128 rows=252,171 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 3253kB
8. 81.159 431.793 ↓ 1.6 252,171 1

Unique (cost=0.42..44,204.72 rows=156,402 width=4) (actual time=0.014..431.793 rows=252,171 loops=1)

9. 350.634 350.634 ↑ 1.0 423,444 1

Index Only Scan using claims_events_id_idx on claims (cost=0.42..43,146.11 rows=423,444 width=4) (actual time=0.013..350.634 rows=423,444 loops=1)

  • Heap Fetches: 423444
10. 48.730 512.856 ↑ 1.0 167,589 1

Hash (cost=30,120.27..30,120.27 rows=167,728 width=24) (actual time=512.856..512.856 rows=167,589 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2899kB
11. 267.768 464.126 ↑ 1.0 167,589 1

Hash Join (cost=5,875.88..30,120.27 rows=167,728 width=24) (actual time=74.982..464.126 rows=167,589 loops=1)

  • Hash Cond: (venues.id = venues_profiles.venues_id)
12. 121.844 121.844 ↑ 1.0 415,935 1

Seq Scan on venues (cost=0.00..15,475.35 rows=415,935 width=20) (actual time=0.263..121.844 rows=415,935 loops=1)

13. 42.516 74.514 ↑ 1.0 167,728 1

Hash (cost=3,123.28..3,123.28 rows=167,728 width=8) (actual time=74.514..74.514 rows=167,728 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 2655kB
14. 31.998 31.998 ↑ 1.0 167,728 1

Seq Scan on venues_profiles (cost=0.00..3,123.28 rows=167,728 width=8) (actual time=0.008..31.998 rows=167,728 loops=1)