explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vVKr

Settings
# exclusive inclusive rows x rows loops node
1. 342.935 3,203.137 ↑ 1.0 423,444 1

Hash Join (cost=123,826.50..169,323.43 rows=423,444 width=24) (actual time=1,893.138..3,203.137 rows=423,444 loops=1)

  • Hash Cond: (events_venues.venues_profiles_id = venues_profiles.id)
2. 749.783 2,360.967 ↑ 1.0 423,444 1

Hash Join (cost=90,626.63..126,008.21 rows=423,444 width=8) (actual time=1,393.834..2,360.967 rows=423,444 loops=1)

  • Hash Cond: (events_venues.events_id = events.id)
3. 217.590 217.590 ↑ 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.013..217.590 rows=1,059,210 loops=1)

4. 139.441 1,393.594 ↑ 1.0 423,444 1

Hash (cost=83,678.58..83,678.58 rows=423,444 width=8) (actual time=1,393.594..1,393.594 rows=423,444 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 3107kB
5. 511.295 1,254.153 ↑ 1.0 423,444 1

Hash Join (cost=52,586.79..83,678.58 rows=423,444 width=8) (actual time=581.256..1,254.153 rows=423,444 loops=1)

  • Hash Cond: (claims.events_id = events.id)
6. 161.828 161.828 ↑ 1.0 423,444 1

Seq Scan on claims (cost=0.00..17,822.44 rows=423,444 width=4) (actual time=0.013..161.828 rows=423,444 loops=1)

7. 334.760 581.030 ↑ 1.0 1,058,835 1

Hash (cost=35,214.35..35,214.35 rows=1,058,835 width=4) (actual time=581.030..581.030 rows=1,058,835 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3369kB
8. 246.270 246.270 ↑ 1.0 1,058,835 1

Seq Scan on events (cost=0.00..35,214.35 rows=1,058,835 width=4) (actual time=0.008..246.270 rows=1,058,835 loops=1)

9. 57.501 499.235 ↑ 1.0 167,589 1

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

  • Buckets: 65536 Batches: 4 Memory Usage: 2735kB
10. 284.644 441.734 ↑ 1.0 167,589 1

Hash Join (cost=5,875.88..30,120.27 rows=167,728 width=20) (actual time=68.799..441.734 rows=167,589 loops=1)

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

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

12. 37.918 68.616 ↑ 1.0 167,728 1

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

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

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