explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fqe0

Settings
# exclusive inclusive rows x rows loops node
1. 24.163 946.066 ↑ 1.0 34,628 1

Hash Left Join (cost=49,721.98..52,875.86 rows=35,038 width=652) (actual time=854.926..946.066 rows=34,628 loops=1)

  • Hash Cond: (l."Id" = hl."EventSSId")
2.          

CTE price_suggest

3. 1.110 1.745 ↑ 1.0 1,373 1

HashAggregate (cost=100.78..114.51 rows=1,373 width=16) (actual time=1.254..1.745 rows=1,373 loops=1)

  • Group Key: activity_listing."EventSSId
4. 0.635 0.635 ↓ 1.0 1,659 1

Seq Scan on activity_listing (cost=0.00..92.52 rows=1,652 width=16) (actual time=0.012..0.635 rows=1,659 loops=1)

5. 24.445 921.875 ↑ 1.0 34,628 1

Hash Left Join (cost=49,606.11..52,317.62 rows=35,038 width=569) (actual time=854.879..921.875 rows=34,628 loops=1)

  • Hash Cond: (l."TicketRequestId" = sl."TicketRequestId")
6. 41.457 854.368 ↑ 1.0 34,628 1

Hash Right Join (cost=45,713.87..48,272.21 rows=35,038 width=565) (actual time=811.783..854.368 rows=34,628 loops=1)

  • Hash Cond: (ps.event_id = l."Id")
7. 2.509 2.509 ↑ 1.0 1,373 1

CTE Scan on price_suggest ps (cost=0.00..27.46 rows=1,373 width=16) (actual time=1.257..2.509 rows=1,373 loops=1)

8. 67.703 810.402 ↑ 1.0 34,628 1

Hash (cost=42,777.90..42,777.90 rows=35,038 width=557) (actual time=810.402..810.402 rows=34,628 loops=1)

  • Buckets: 8192 Batches: 8 Memory Usage: 2180kB
9. 31.503 742.699 ↑ 1.0 34,628 1

Hash Left Join (cost=29,027.78..42,777.90 rows=35,038 width=557) (actual time=356.903..742.699 rows=34,628 loops=1)

  • Hash Cond: (l."Id" = i."EventSSId")
10. 31.389 699.242 ↑ 1.0 34,427 1

Hash Left Join (cost=28,569.77..41,464.66 rows=35,038 width=533) (actual time=344.885..699.242 rows=34,427 loops=1)

  • Hash Cond: (l."Id" = g."EventSSId")
11. 25.516 653.383 ↑ 1.0 34,427 1

Hash Join (cost=27,845.50..40,648.41 rows=35,038 width=529) (actual time=330.283..653.383 rows=34,427 loops=1)

  • Hash Cond: (u."TenantId" = t."Id")
12. 28.126 626.996 ↑ 1.0 34,427 1

Hash Join (cost=27,663.39..39,984.52 rows=35,038 width=511) (actual time=329.395..626.996 rows=34,427 loops=1)

  • Hash Cond: (v.venue_city = c.city_id)
13. 49.151 571.968 ↑ 1.0 34,430 1

Hash Join (cost=26,343.97..38,183.33 rows=35,038 width=485) (actual time=302.269..571.968 rows=34,430 loops=1)

  • Hash Cond: (e.venue_id = v.venue_id)
14. 91.450 517.235 ↑ 1.0 34,430 1

Hash Join (cost=25,884.18..37,631.52 rows=35,038 width=460) (actual time=296.642..517.235 rows=34,430 loops=1)

  • Hash Cond: (l."UserId" = u."Id")
15. 101.911 378.728 ↑ 1.0 34,430 1

Hash Join (cost=21,924.63..29,500.99 rows=35,038 width=369) (actual time=249.333..378.728 rows=34,430 loops=1)

  • Hash Cond: (l."ApiEventId" = e.event_id)
16. 27.728 27.728 ↑ 1.0 35,016 1

Seq Scan on "EventSS" l (cost=0.00..1,611.38 rows=35,038 width=316) (actual time=0.008..27.728 rows=35,016 loops=1)

17. 127.511 249.089 ↑ 1.0 272,596 1

Hash (cost=15,588.06..15,588.06 rows=272,606 width=61) (actual time=249.089..249.089 rows=272,596 loops=1)

  • Buckets: 65536 Batches: 8 Memory Usage: 3564kB
18. 121.578 121.578 ↑ 1.0 272,596 1

Seq Scan on tn_events e (cost=0.00..15,588.06 rows=272,606 width=61) (actual time=0.007..121.578 rows=272,596 loops=1)

19. 23.422 47.057 ↑ 1.0 35,317 1

Hash (cost=2,860.02..2,860.02 rows=35,402 width=128) (actual time=47.057..47.057 rows=35,317 loops=1)

  • Buckets: 32768 Batches: 2 Memory Usage: 2797kB
20. 23.635 23.635 ↑ 1.0 35,317 1

Seq Scan on "AspNetUsers" u (cost=0.00..2,860.02 rows=35,402 width=128) (actual time=0.005..23.635 rows=35,317 loops=1)

21. 2.753 5.582 ↓ 1.0 7,814 1

Hash (cost=362.13..362.13 rows=7,813 width=37) (actual time=5.582..5.582 rows=7,814 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 619kB
22. 2.829 2.829 ↓ 1.0 7,814 1

Seq Scan on tn_venues v (cost=0.00..362.13 rows=7,813 width=37) (actual time=0.009..2.829 rows=7,814 loops=1)

23. 14.307 26.902 ↑ 1.0 36,863 1

Hash (cost=858.63..858.63 rows=36,863 width=34) (actual time=26.901..26.902 rows=36,863 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3030kB
24. 12.595 12.595 ↑ 1.0 36,863 1

Seq Scan on mv_city_state_country c (cost=0.00..858.63 rows=36,863 width=34) (actual time=0.007..12.595 rows=36,863 loops=1)

25. 0.386 0.871 ↓ 1.0 1,206 1

Hash (cost=167.05..167.05 rows=1,205 width=22) (actual time=0.871..0.871 rows=1,206 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 83kB
26. 0.485 0.485 ↓ 1.0 1,206 1

Seq Scan on "Tenants" t (cost=0.00..167.05 rows=1,205 width=22) (actual time=0.005..0.485 rows=1,206 loops=1)

27. 7.827 14.470 ↓ 1.0 26,033 1

Hash (cost=400.23..400.23 rows=25,923 width=12) (actual time=14.469..14.470 rows=26,033 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1477kB
28. 6.643 6.643 ↓ 1.0 26,033 1

Seq Scan on "ListingTicketGroup" g (cost=0.00..400.23 rows=25,923 width=12) (actual time=0.010..6.643 rows=26,033 loops=1)

29. 3.734 11.954 ↑ 1.0 11,000 1

Hash (cost=319.67..319.67 rows=11,067 width=32) (actual time=11.954..11.954 rows=11,000 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 902kB
30. 3.792 8.220 ↑ 1.0 11,000 1

Append (cost=0.00..319.67 rows=11,067 width=32) (actual time=0.007..8.220 rows=11,000 loops=1)

31. 4.363 4.363 ↑ 1.0 10,850 1

Seq Scan on "ListingSoldInvoices" i (cost=0.00..313.27 rows=10,927 width=32) (actual time=0.006..4.363 rows=10,850 loops=1)

32. 0.065 0.065 ↓ 1.1 150 1

Seq Scan on resale_invoices i_1 (cost=0.00..6.40 rows=140 width=32) (actual time=0.006..0.065 rows=150 loops=1)

33. 2.374 43.062 ↓ 1.0 7,970 1

Hash (cost=3,792.89..3,792.89 rows=7,948 width=8) (actual time=43.062..43.062 rows=7,970 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 376kB
34. 4.508 40.688 ↓ 1.0 7,970 1

Hash Left Join (cost=3,302.55..3,792.89 rows=7,948 width=8) (actual time=34.167..40.688 rows=7,970 loops=1)

  • Hash Cond: (sl."UserId" = slu."Id")
35. 2.214 2.214 ↓ 1.0 7,970 1

Seq Scan on "Resale" sl (cost=0.00..469.48 rows=7,948 width=41) (actual time=0.004..2.214 rows=7,970 loops=1)

36. 13.453 33.966 ↑ 1.0 35,317 1

Hash (cost=2,860.02..2,860.02 rows=35,402 width=41) (actual time=33.966..33.966 rows=35,317 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3030kB
37. 20.513 20.513 ↑ 1.0 35,317 1

Seq Scan on "AspNetUsers" slu (cost=0.00..2,860.02 rows=35,402 width=41) (actual time=0.004..20.513 rows=35,317 loops=1)

38. 0.012 0.028 ↓ 1.8 28 1

Hash (cost=1.16..1.16 rows=16 width=36) (actual time=0.028..0.028 rows=28 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
39. 0.016 0.016 ↓ 1.8 28 1

Seq Scan on "HoldListing" hl (cost=0.00..1.16 rows=16 width=36) (actual time=0.008..0.016 rows=28 loops=1)

Planning time : 3.786 ms