explain.depesz.com

PostgreSQL's explain analyze made readable

Result: htqf

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

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

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

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

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

4. 140.919 1,348.579 ↑ 1.0 423,444 1

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

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

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

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

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

7. 295.299 567.610 ↑ 1.0 1,058,835 1

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

  • Buckets: 131072 Batches: 16 Memory Usage: 3369kB
8. 272.311 272.311 ↑ 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.010..272.311 rows=1,058,835 loops=1)

9. 56.713 494.043 ↑ 1.0 167,589 1

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

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

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

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

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

12. 38.703 69.222 ↑ 1.0 167,728 1

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

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

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