explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aBL

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 5,404.505 ↓ 2.0 4 1

Unique (cost=150,745.33..150,745.35 rows=2 width=24) (actual time=5,404.502..5,404.505 rows=4 loops=1)

2. 0.024 5,404.502 ↓ 2.0 4 1

Sort (cost=150,745.33..150,745.34 rows=2 width=24) (actual time=5,404.501..5,404.502 rows=4 loops=1)

  • Sort Key: e_3.id, e_3.uuid
  • Sort Method: quicksort Memory: 25kB
3. 0.000 5,404.478 ↓ 2.0 4 1

Append (cost=5,882.83..150,745.32 rows=2 width=24) (actual time=2,741.615..5,404.478 rows=4 loops=1)

4. 0.000 2,742.517 ↓ 3.0 3 1

Nested Loop (cost=5,882.83..121,847.35 rows=1 width=24) (actual time=2,741.615..2,742.517 rows=3 loops=1)

  • Join Filter: (e.id <> e_3.id)
5. 5.416 2,742.574 ↓ 3.0 3 1

Gather (cost=5,882.41..121,846.83 rows=1 width=16) (actual time=2,741.592..2,742.574 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 8.348 2,737.158 ↑ 1.0 1 3 / 3

Merge Join (cost=4,882.41..120,846.73 rows=1 width=16) (actual time=2,726.177..2,737.158 rows=1 loops=3)

  • Merge Cond: (e_2.id = pdm.matched_place_description_id)
7. 56.081 2,687.394 ↑ 13.2 96,652 3 / 3

Merge Join (cost=7.36..692,211.12 rows=1,273,852 width=16) (actual time=1.491..2,687.394 rows=96,652 loops=3)

  • Merge Cond: (cvp_2.place_description_id = e_2.id)
8. 82.002 2,496.600 ↑ 13.2 96,652 3 / 3

Nested Loop (cost=0.86..883,818.68 rows=1,273,852 width=8) (actual time=1.332..2,496.600 rows=96,652 loops=3)

9. 94.958 94.958 ↑ 13.2 96,652 3 / 3

Parallel Index Scan using place_description_current_version_pointer_ux1 on place_description_current_version_pointer cvp_2 (cost=0.43..98,531.89 rows=1,273,852 width=16) (actual time=0.728..94.958 rows=96,652 loops=3)

10. 2,319.640 2,319.640 ↑ 1.0 1 289,955 / 3

Index Only Scan using place_description_version_pkey on place_description_version v_2 (cost=0.43..0.62 rows=1 width=8) (actual time=0.024..0.024 rows=1 loops=289,955)

  • Index Cond: (id = cvp_2.place_description_version_id)
  • Heap Fetches: 100469
11. 134.713 134.713 ↑ 10.7 290,068 3 / 3

Index Only Scan using place_description_pkey on place_description e_2 (cost=0.43..129,385.70 rows=3,097,706 width=8) (actual time=0.040..134.713 rows=290,068 loops=3)

  • Heap Fetches: 289953
12. 0.025 41.416 ↑ 1.0 3 3 / 3

Sort (cost=4,837.38..4,837.39 rows=3 width=32) (actual time=41.414..41.416 rows=3 loops=3)

  • Sort Key: pdm.matched_place_description_id
  • Sort Method: quicksort Memory: 25kB
13. 21.492 41.391 ↑ 1.0 3 3 / 3

Hash Join (cost=30.26..4,837.36 rows=3 width=32) (actual time=31.281..41.391 rows=3 loops=3)

  • Hash Cond: (cvp_3.place_subscription_version_id = v_3.id)
14. 19.759 19.759 ↑ 1.0 217,568 3 / 3

Seq Scan on place_subscription_current_version_pointer cvp_3 (cost=0.00..3,990.78 rows=217,678 width=16) (actual time=0.006..19.759 rows=217,568 loops=3)

15. 0.003 0.140 ↑ 1.0 3 3 / 3

Hash (cost=30.22..30.22 rows=3 width=32) (actual time=0.140..0.140 rows=3 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
16. 0.001 0.137 ↑ 1.0 3 3 / 3

Nested Loop (cost=3.41..30.22 rows=3 width=32) (actual time=0.122..0.137 rows=3 loops=3)

17. 0.002 0.111 ↓ 2.5 5 3 / 3

Nested Loop (cost=2.99..29.32 rows=2 width=16) (actual time=0.107..0.111 rows=5 loops=3)

18. 0.000 0.092 ↑ 1.0 1 3 / 3

Nested Loop (cost=2.55..27.58 rows=1 width=24) (actual time=0.091..0.092 rows=1 loops=3)

19. 0.001 0.074 ↑ 1.0 1 3 / 3

Nested Loop (cost=2.12..26.96 rows=1 width=16) (actual time=0.072..0.074 rows=1 loops=3)

20. 0.001 0.061 ↑ 1.0 1 3 / 3

Nested Loop (cost=1.69..26.45 rows=1 width=32) (actual time=0.060..0.061 rows=1 loops=3)

21. 0.002 0.050 ↑ 1.0 1 3 / 3

Nested Loop (cost=1.26..25.32 rows=1 width=16) (actual time=0.048..0.050 rows=1 loops=3)

22. 0.001 0.038 ↑ 1.0 1 3 / 3

Nested Loop (cost=0.84..16.89 rows=1 width=16) (actual time=0.037..0.038 rows=1 loops=3)

23. 0.027 0.027 ↑ 1.0 1 3 / 3

Index Only Scan using place_subscription_pkey on place_subscription e (cost=0.42..8.44 rows=1 width=8) (actual time=0.027..0.027 rows=1 loops=3)

  • Index Cond: (id = 163139)
  • Heap Fetches: 1
24. 0.010 0.010 ↑ 1.0 1 3 / 3

Index Scan using place_subscription_current_version_pointer_ux1 on place_subscription_current_version_pointer cvp (cost=0.42..8.44 rows=1 width=16) (actual time=0.009..0.010 rows=1 loops=3)

  • Index Cond: (place_subscription_id = 163139)
25. 0.010 0.010 ↑ 1.0 1 3 / 3

Index Scan using place_subscription_version_pkey on place_subscription_version v (cost=0.42..8.44 rows=1 width=16) (actual time=0.010..0.010 rows=1 loops=3)

  • Index Cond: (id = cvp.place_subscription_version_id)
26. 0.010 0.010 ↑ 1.0 1 3 / 3

Index Scan using place_description_current_version_pointer_ux1 on place_description_current_version_pointer cvp_1 (cost=0.43..1.12 rows=1 width=16) (actual time=0.010..0.010 rows=1 loops=3)

  • Index Cond: (place_description_id = v.place_description_id)
27. 0.012 0.012 ↑ 1.0 1 3 / 3

Index Only Scan using place_description_pkey on place_description e_1 (cost=0.43..0.51 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=3)

  • Index Cond: (id = cvp_1.place_description_id)
  • Heap Fetches: 1
28. 0.018 0.018 ↑ 1.0 1 3 / 3

Index Only Scan using place_description_version_pkey on place_description_version v_1 (cost=0.43..0.62 rows=1 width=8) (actual time=0.018..0.018 rows=1 loops=3)

  • Index Cond: (id = cvp_1.place_description_version_id)
  • Heap Fetches: 1
29. 0.017 0.017 ↑ 8.8 5 3 / 3

Index Only Scan using place_description_match_ux1 on place_description_match pdm (cost=0.43..1.31 rows=44 width=16) (actual time=0.016..0.017 rows=5 loops=3)

  • Index Cond: (place_description_version_id = v_1.id)
  • Heap Fetches: 5
30. 0.025 0.025 ↑ 1.0 1 15 / 3

Index Scan using place_subscription_version_ix1 on place_subscription_version v_3 (cost=0.42..0.44 rows=1 width=16) (actual time=0.004..0.005 rows=1 loops=15)

  • Index Cond: (place_description_id = pdm.matched_place_description_id)
31. 0.027 0.027 ↑ 1.0 1 3

Index Scan using place_subscription_pkey on place_subscription e_3 (cost=0.42..0.50 rows=1 width=24) (actual time=0.009..0.009 rows=1 loops=3)

  • Index Cond: (id = cvp_3.place_subscription_id)
32. 21.615 2,662.009 ↑ 1.0 1 1

Gather (cost=19,808.95..28,897.95 rows=1 width=24) (actual time=1,808.726..2,662.009 rows=1 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
33. 11.885 2,640.394 ↓ 0.0 0 2 / 2

Hash Join (cost=18,808.95..27,897.85 rows=1 width=24) (actual time=2,230.419..2,640.394 rows=0 loops=2)

  • Hash Cond: (v_6.place_description_id = e_5.id)
  • Join Filter: (e_4.id <> e_6.id)
  • Rows Removed by Join Filter: 0
34. 1,279.363 2,628.411 ↑ 1.2 108,784 2 / 2

Hash Join (cost=18,781.36..27,390.08 rows=128,046 width=32) (actual time=370.260..2,628.411 rows=108,784 loops=2)

  • Hash Cond: (cvp_6.place_subscription_id = e_6.id)
35. 964.727 1,163.929 ↑ 1.2 108,784 2 / 2

Hash Join (cost=9,711.31..15,456.91 rows=128,046 width=16) (actual time=184.873..1,163.929 rows=108,784 loops=2)

  • Hash Cond: (cvp_6.place_subscription_version_id = v_6.id)
36. 14.851 14.851 ↑ 1.2 108,784 2 / 2

Parallel Seq Scan on place_subscription_current_version_pointer cvp_6 (cost=0.00..3,094.46 rows=128,046 width=16) (actual time=0.004..14.851 rows=108,784 loops=2)

37. 144.173 184.351 ↑ 1.0 217,571 2 / 2

Hash (cost=5,928.14..5,928.14 rows=217,614 width=16) (actual time=184.351..184.351 rows=217,571 loops=2)

  • Buckets: 131072 Batches: 4 Memory Usage: 3580kB
38. 40.178 40.178 ↑ 1.0 217,571 2 / 2

Seq Scan on place_subscription_version v_6 (cost=0.00..5,928.14 rows=217,614 width=16) (actual time=0.008..40.178 rows=217,571 loops=2)

39. 159.554 185.119 ↓ 1.0 217,568 2 / 2

Hash (cost=5,076.13..5,076.13 rows=217,513 width=24) (actual time=185.119..185.119 rows=217,568 loops=2)

  • Buckets: 65536 Batches: 4 Memory Usage: 3493kB
40. 25.565 25.565 ↓ 1.0 217,568 2 / 2

Seq Scan on place_subscription e_6 (cost=0.00..5,076.13 rows=217,513 width=24) (actual time=0.005..25.565 rows=217,568 loops=2)

41. 0.004 0.098 ↑ 1.0 1 2 / 2

Hash (cost=27.58..27.58 rows=1 width=32) (actual time=0.098..0.098 rows=1 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
42. 0.001 0.094 ↑ 1.0 1 2 / 2

Nested Loop (cost=2.55..27.58 rows=1 width=32) (actual time=0.092..0.094 rows=1 loops=2)

43. 0.001 0.078 ↑ 1.0 1 2 / 2

Nested Loop (cost=2.12..26.96 rows=1 width=40) (actual time=0.077..0.078 rows=1 loops=2)

44. 0.002 0.061 ↑ 1.0 1 2 / 2

Nested Loop (cost=1.69..26.45 rows=1 width=32) (actual time=0.059..0.061 rows=1 loops=2)

45. 0.004 0.047 ↑ 1.0 1 2 / 2

Nested Loop (cost=1.26..25.32 rows=1 width=16) (actual time=0.046..0.047 rows=1 loops=2)

46. 0.002 0.031 ↑ 1.0 1 2 / 2

Nested Loop (cost=0.84..16.89 rows=1 width=16) (actual time=0.030..0.031 rows=1 loops=2)

47. 0.020 0.020 ↑ 1.0 1 2 / 2

Index Only Scan using place_subscription_pkey on place_subscription e_4 (cost=0.42..8.44 rows=1 width=8) (actual time=0.019..0.020 rows=1 loops=2)

  • Index Cond: (id = 163139)
  • Heap Fetches: 1
48. 0.009 0.009 ↑ 1.0 1 2 / 2

Index Scan using place_subscription_current_version_pointer_ux1 on place_subscription_current_version_pointer cvp_4 (cost=0.42..8.44 rows=1 width=16) (actual time=0.009..0.009 rows=1 loops=2)

  • Index Cond: (place_subscription_id = 163139)
49. 0.012 0.012 ↑ 1.0 1 2 / 2

Index Scan using place_subscription_version_pkey on place_subscription_version v_4 (cost=0.42..8.44 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=2)

  • Index Cond: (id = cvp_4.place_subscription_version_id)
50. 0.012 0.012 ↑ 1.0 1 2 / 2

Index Scan using place_description_current_version_pointer_ux1 on place_description_current_version_pointer cvp_5 (cost=0.43..1.12 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=2)

  • Index Cond: (place_description_id = v_4.place_description_id)
51. 0.016 0.016 ↑ 1.0 1 2 / 2

Index Only Scan using place_description_pkey on place_description e_5 (cost=0.43..0.51 rows=1 width=8) (actual time=0.016..0.016 rows=1 loops=2)

  • Index Cond: (id = cvp_5.place_description_id)
  • Heap Fetches: 1
52. 0.015 0.015 ↑ 1.0 1 2 / 2

Index Only Scan using place_description_version_pkey on place_description_version v_5 (cost=0.43..0.62 rows=1 width=8) (actual time=0.014..0.015 rows=1 loops=2)

  • Index Cond: (id = cvp_5.place_description_version_id)
  • Heap Fetches: 1
Planning time : 7.700 ms
Execution time : 5,405.745 ms