explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MB1s

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 6,175.707 ↑ 1,414.5 11 1

Append (cost=1,156,329.43..1,156,848.49 rows=15,560 width=96) (actual time=6,144.974..6,175.707 rows=11 loops=1)

2.          

CTE picklist_0

3. 0.029 0.029 ↑ 1.0 1 1

Seq Scan on t60_opportunitystagenamepicklistdim (cost=0.00..2.24 rows=1 width=4) (actual time=0.024..0.029 rows=1 loops=1)

  • Filter: (correlated_value = 'Win - 100%'::text)
  • Rows Removed by Filter: 18
4.          

CTE docd_cte_1

5. 20.298 1,733.224 ↑ 2.8 13,187 1

HashAggregate (cost=405,855.62..406,231.02 rows=37,540 width=4) (actual time=1,731.570..1,733.224 rows=13,187 loops=1)

  • Group Key: t67_distinct_opp_owner_closedate.c759_ownerid
6. 88.728 1,712.926 ↑ 1.0 99,727 1

Hash Join (cost=225,550.22..405,604.64 rows=100,391 width=4) (actual time=848.293..1,712.926 rows=99,727 loops=1)

  • Hash Cond: (t67_distinct_opp_owner_closedate.c759_ownerid = t55_userrolehierarchy.sid)
7. 777.702 777.702 ↓ 1.1 213,595 1

Seq Scan on t67_distinct_opp_owner_closedate (cost=0.00..156,103.63 rows=200,782 width=4) (actual time=0.334..777.702 rows=213,595 loops=1)

  • Filter: ((c760_closedate >= 20190202) AND (c760_closedate <= 20190503))
  • Rows Removed by Filter: 5954245
8. 51.742 846.496 ↑ 1.0 363,469 1

Hash (cost=219,341.13..219,341.13 rows=378,407 width=4) (actual time=846.496..846.496 rows=363,469 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 2639kB
9. 51.894 794.754 ↑ 1.0 363,469 1

Unique (cost=213,665.03..215,557.06 rows=378,407 width=4) (actual time=696.162..794.754 rows=363,469 loops=1)

10. 225.381 742.860 ↓ 1.0 389,844 1

Sort (cost=213,665.03..214,611.04 rows=378,407 width=4) (actual time=696.161..742.860 rows=389,844 loops=1)

  • Sort Key: t55_userrolehierarchy.sid
  • Sort Method: external merge Disk: 5336kB
11. 30.636 517.479 ↓ 1.0 389,844 1

Append (cost=25,500.11..173,429.91 rows=378,407 width=4) (actual time=72.085..517.479 rows=389,844 loops=1)

12. 130.237 363.755 ↓ 1.2 389,678 1

Hash Join (cost=25,500.11..120,368.88 rows=316,841 width=4) (actual time=72.085..363.755 rows=389,678 loops=1)

  • Hash Cond: (t55_userrolehierarchy.c697_user_role_id = t33_userroledim.sid)
13. 171.051 218.491 ↑ 1.0 550,251 1

Bitmap Heap Scan on t55_userrolehierarchy (cost=16,969.25..109,211.80 rows=563,970 width=8) (actual time=56.917..218.491 rows=550,251 loops=1)

  • Recheck Cond: ((c698_ancestor_role_id = 437) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=50118
14. 47.440 47.440 ↑ 1.0 550,257 1

Bitmap Index Scan on idx_49_t55_userrolehierarchy_c698_ancestor_role_id_end_stamp_st (cost=0.00..16,828.26 rows=563,970 width=0) (actual time=47.440..47.440 rows=550,257 loops=1)

  • Index Cond: ((c698_ancestor_role_id = 437) AND (end_stamp = '32503680000000'::bigint))
15. 3.920 15.027 ↓ 1.0 26,450 1

Hash (cost=8,207.82..8,207.82 rows=25,843 width=4) (actual time=15.027..15.027 rows=26,450 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1186kB
16. 9.201 11.107 ↓ 1.0 26,450 1

Bitmap Heap Scan on t33_userroledim (cost=720.57..8,207.82 rows=25,843 width=4) (actual time=2.016..11.107 rows=26,450 loops=1)

  • Recheck Cond: ((end_stamp = '32503680000000'::bigint) AND ((c412_portaltype IS NULL) OR (c412_portaltype = 'None'::text)))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=735
17. 1.906 1.906 ↓ 1.0 26,451 1

Bitmap Index Scan on "idx_9_t33_userroledim_sid_start_stamp_end_stamp_(c412_portaltyp" (cost=0.00..714.11 rows=25,843 width=0) (actual time=1.906..1.906 rows=26,451 loops=1)

  • Index Cond: (end_stamp = '32503680000000'::bigint)
18. 106.776 123.088 ↑ 370.9 166 1

Bitmap Heap Scan on t47_userdim (cost=5,627.51..49,276.97 rows=61,566 width=4) (actual time=18.999..123.088 rows=166 loops=1)

  • Recheck Cond: ((c577_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND (c587_usertype = 'Standard'::text))
  • Rows Removed by Filter: 188439
  • Heap Blocks: exact=15559
19. 16.312 16.312 ↓ 1.0 188,605 1

Bitmap Index Scan on idx_6_t47_userdim_c577_userroleid_end_stamp_start_stamp_null (cost=0.00..5,612.12 rows=187,969 width=0) (actual time=16.312..16.312 rows=188,605 loops=1)

  • Index Cond: ((c577_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
20.          

CTE picklist_4

21. 0.017 0.017 ↑ 1.0 1 1

Seq Scan on t60_opportunitystagenamepicklistdim t60_opportunitystagenamepicklistdim_1 (cost=0.00..2.24 rows=1 width=4) (actual time=0.012..0.017 rows=1 loops=1)

  • Filter: (correlated_value = 'Lost, Cancelled - 0%'::text)
  • Rows Removed by Filter: 18
22.          

CTE openwont1

23. 52.587 5,874.439 ↑ 1.5 55,107 1

Merge Right Join (cost=619,880.64..628,363.40 rows=81,654 width=34) (actual time=5,775.380..5,874.439 rows=55,107 loops=1)

  • Merge Cond: ((t54_clari_conversion_rate_1.sid = t56_oppfact_1.c701_opp_currency_code) AND (t54_clari_conversion_rate_1.rate_date = t56_oppfact_1.c713_opp_close_date))
24. 4.574 38.757 ↑ 1.0 65,896 1

Merge Append (cost=0.31..5,835.47 rows=66,109 width=16) (actual time=0.020..38.757 rows=65,896 loops=1)

  • Sort Key: t54_clari_conversion_rate_1.sid, t54_clari_conversion_rate_1.rate_date
25. 0.005 0.005 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1)

  • Sort Key: t54_clari_conversion_rate_1.sid, t54_clari_conversion_rate_1.rate_date
  • Sort Method: quicksort Memory: 25kB
26. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on t54_clari_conversion_rate t54_clari_conversion_rate_1 (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
27. 34.178 34.178 ↑ 1.0 65,896 1

Index Scan using t54_clari_conversion_rate_usd_sidratedateunique on t54_clari_conversion_rate_usd t54_clari_conversion_rate_usd_1 (cost=0.29..5,009.08 rows=66,108 width=16) (actual time=0.014..34.178 rows=65,896 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
28. 5.514 5,782.059 ↑ 1.5 55,107 1

Materialize (cost=619,035.63..619,443.90 rows=81,654 width=56) (actual time=5,768.373..5,782.059 rows=55,107 loops=1)

29. 59.179 5,776.545 ↑ 1.5 55,107 1

Sort (cost=619,035.63..619,239.77 rows=81,654 width=56) (actual time=5,768.370..5,776.545 rows=55,107 loops=1)

  • Sort Key: t56_oppfact_1.c701_opp_currency_code, t56_oppfact_1.c713_opp_close_date
  • Sort Method: external sort Disk: 3768kB
30. 46.589 5,717.366 ↑ 1.5 55,107 1

Nested Loop Left Join (cost=220,191.41..609,580.79 rows=81,654 width=56) (actual time=5,435.871..5,717.366 rows=55,107 loops=1)

31. 15.619 5,505.456 ↑ 1.5 55,107 1

Merge Right Join (cost=220,190.85..227,244.66 rows=81,654 width=28) (actual time=5,435.844..5,505.456 rows=55,107 loops=1)

  • Merge Cond: ((t54_clari_conversion_rate.sid = t56_oppfact.c701_opp_currency_code) AND (t54_clari_conversion_rate.rate_date = t56_oppfact.c713_opp_close_date))
32. 4.946 43.642 ↑ 1.0 65,896 1

Merge Append (cost=0.31..5,835.47 rows=66,109 width=16) (actual time=0.029..43.642 rows=65,896 loops=1)

  • Sort Key: t54_clari_conversion_rate.sid, t54_clari_conversion_rate.rate_date
33. 0.006 0.006 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: t54_clari_conversion_rate.sid, t54_clari_conversion_rate.rate_date
  • Sort Method: quicksort Memory: 25kB
34. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on t54_clari_conversion_rate (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
35. 38.690 38.690 ↑ 1.0 65,896 1

Index Scan using t54_clari_conversion_rate_usd_sidratedateunique on t54_clari_conversion_rate_usd (cost=0.29..5,009.08 rows=66,108 width=16) (actual time=0.023..38.690 rows=65,896 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
36. 5.631 5,446.195 ↑ 1.5 55,107 1

Materialize (cost=220,190.54..220,598.81 rows=81,654 width=28) (actual time=5,432.201..5,446.195 rows=55,107 loops=1)

37. 62.091 5,440.564 ↑ 1.5 55,107 1

Sort (cost=220,190.54..220,394.67 rows=81,654 width=28) (actual time=5,432.198..5,440.564 rows=55,107 loops=1)

  • Sort Key: t56_oppfact.c701_opp_currency_code, t56_oppfact.c713_opp_close_date
  • Sort Method: external merge Disk: 2264kB
38. 9.442 5,378.473 ↑ 1.5 55,107 1

Nested Loop (cost=845.23..211,572.20 rows=81,654 width=28) (actual time=1,740.233..5,378.473 rows=55,107 loops=1)

39. 6.646 1,742.606 ↓ 65.9 13,187 1

HashAggregate (cost=844.65..846.65 rows=200 width=4) (actual time=1,739.270..1,742.606 rows=13,187 loops=1)

  • Group Key: cte0_6.c1
40. 1,735.960 1,735.960 ↑ 2.8 13,187 1

CTE Scan on docd_cte_1 cte0_6 (cost=0.00..750.80 rows=37,540 width=4) (actual time=1,731.572..1,735.960 rows=13,187 loops=1)

41. 3,626.407 3,626.425 ↑ 1.2 4 13,187

Index Scan using t56_oppfact_239_timestamp on t56_oppfact (cost=0.58..1,053.58 rows=5 width=32) (actual time=0.224..0.275 rows=4 loops=13,187)

  • Index Cond: ((c703_opp_ownerid = cte0_6.c1) AND (c703_opp_ownerid IS NOT NULL) AND (start_stamp <= '1552719599999'::bigint) AND (end_stamp > '1552719599999'::bigint))
  • Filter: ((NOT deleted) AND (c713_opp_close_date >= 20190202) AND (c713_opp_close_date <= 20190503) AND (NOT (hashed SubPlan 7)))
  • Rows Removed by Filter: 258
42.          

SubPlan (for Index Scan)

43. 0.018 0.018 ↑ 1.0 1 1

CTE Scan on picklist_4 cte0_5 (cost=0.00..0.02 rows=1 width=4) (actual time=0.013..0.018 rows=1 loops=1)

44. 165.321 165.321 ↑ 1.0 1 55,107

Index Scan using t56_oppfact_sidendstampunique on t56_oppfact t56_oppfact_1 (cost=0.56..4.67 rows=1 width=28) (actual time=0.003..0.003 rows=1 loops=55,107)

  • Index Cond: ((t56_oppfact.sid = sid) AND (t56_oppfact.sid = sid) AND (end_stamp > '1572073199999'::bigint))
  • Filter: ((NOT deleted) AND (start_stamp <= '1572073199999'::bigint))
  • Rows Removed by Filter: 0
45.          

SubPlan (for Merge Right Join)

46. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on picklist_0 cte0_2 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

47. 1.034 1.034 ↑ 2.8 13,187 1

CTE Scan on docd_cte_1 cte0_3 (cost=0.00..750.80 rows=37,540 width=4) (actual time=0.001..1.034 rows=13,187 loops=1)

48. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on picklist_0 cte0_4 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.001 rows=1 loops=1)

49.          

CTE openwont1ids

50. 26.706 5,924.774 ↓ 275.5 55,107 1

HashAggregate (cost=1,837.21..1,839.21 rows=200 width=4) (actual time=5,915.762..5,924.774 rows=55,107 loops=1)

  • Group Key: cte0_7.c1
51. 5,898.068 5,898.068 ↑ 1.5 55,107 1

CTE Scan on openwont1 cte0_7 (cost=0.00..1,633.08 rows=81,654 width=4) (actual time=5,775.382..5,898.068 rows=55,107 loops=1)

52.          

CTE bucketab

53. 19.008 30.684 ↑ 816.5 10 1

HashAggregate (cost=2,857.89..2,939.54 rows=8,165 width=68) (actual time=30.649..30.684 rows=10 loops=1)

  • Group Key: cte0_8.c5, CASE WHEN cte0_8.c6 THEN CASE WHEN cte0_8.c4 THEN 'convertedWon'::text ELSE 'convertedOpen'::text END ELSE CASE WHEN cte0_8.c4 THEN 'unconvertedWon'::text ELSE 'unconvertedOpen'::text END END, cte0_8.c3
54. 11.676 11.676 ↑ 1.5 55,107 1

CTE Scan on openwont1 cte0_8 (cost=0.00..1,633.08 rows=81,654 width=64) (actual time=0.035..11.676 rows=55,107 loops=1)

55.          

CTE picklist_5

56. 0.000 0.000 ↓ 0.0 0

Seq Scan on t60_opportunitystagenamepicklistdim t60_opportunitystagenamepicklistdim_2 (cost=0.00..2.24 rows=2 width=4) (never executed)

  • Filter: (correlated_value = ANY ('{"Lost, Cancelled - 0%","Win - 100%"}'::text[]))
57.          

CTE bucketd

58. 3.191 6,144.959 ↑ 7,395.0 1 1

GroupAggregate (cost=116,653.75..116,949.55 rows=7,395 width=120) (actual time=6,144.959..6,144.959 rows=1 loops=1)

  • Group Key: '1552719599999'::bigint, (CASE WHEN (t56_oppfact_3.sid IS NULL) THEN 'trendNew'::text WHEN (NOT (hashed SubPlan 12)) THEN CASE WHEN (t56_oppfact_3.c713_opp_close_date > 20190503) THEN 'pulledIn'::text WHEN (t56_oppfact_3.c713_opp_close_date < 20190202) THEN 'pushedIn'::text WHEN ((t56_oppfact_3.c713_opp_close_date >= 20190202) AND (t56_oppfact_3.c713_opp_close_date <= 20190503) AND (hashed SubPlan 13) AND (t56_oppfact_3.c703_opp_ownerid IS NOT NULL)) THEN 'other'::text ELSE 'ownerChange'::text END ELSE 'other'::text END)
59. 4.662 6,141.768 ↓ 1.9 14,122 1

Sort (cost=115,809.06..115,827.54 rows=7,395 width=60) (actual time=6,140.791..6,141.768 rows=14,122 loops=1)

  • Sort Key: (CASE WHEN (t56_oppfact_3.sid IS NULL) THEN 'trendNew'::text WHEN (NOT (hashed SubPlan 12)) THEN CASE WHEN (t56_oppfact_3.c713_opp_close_date > 20190503) THEN 'pulledIn'::text WHEN (t56_oppfact_3.c713_opp_close_date < 20190202) THEN 'pushedIn'::text WHEN ((t56_oppfact_3.c713_opp_close_date >= 20190202) AND (t56_oppfact_3.c713_opp_close_date <= 20190503) AND (hashed SubPlan 13) AND (t56_oppfact_3.c703_opp_ownerid IS NOT NULL)) THEN 'other'::text ELSE 'ownerChange'::text END ELSE 'other'::text END)
  • Sort Method: quicksort Memory: 1488kB
60. 9.149 6,137.106 ↓ 1.9 14,122 1

Nested Loop Left Join (cost=1,699.49..115,333.84 rows=7,395 width=60) (actual time=5,958.083..6,137.106 rows=14,122 loops=1)

61. 4.939 6,099.713 ↓ 1.9 14,122 1

Nested Loop Left Join (cost=854.23..80,910.20 rows=7,395 width=20) (actual time=5,958.066..6,099.713 rows=14,122 loops=1)

62. 7.036 6,066.530 ↓ 1.9 14,122 1

Hash Join (cost=854.23..78,256.04 rows=7,395 width=20) (actual time=5,958.041..6,066.530 rows=14,122 loops=1)

  • Hash Cond: (t56_oppfact_2.c703_opp_ownerid = cte0_12.c1)
63. 5.831 6,052.267 ↓ 2.5 37,194 1

Nested Loop (cost=5.08..77,350.44 rows=14,790 width=24) (actual time=5,950.212..6,052.267 rows=37,194 loops=1)

64. 0.004 0.036 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=4) (actual time=0.035..0.036 rows=1 loops=1)

  • Group Key: cte0_13.c1
65. 0.032 0.032 ↑ 1.0 1 1

CTE Scan on picklist_0 cte0_13 (cost=0.00..0.02 rows=1 width=4) (actual time=0.027..0.032 rows=1 loops=1)

66. 110.143 6,046.400 ↓ 2.5 37,194 1

Index Scan using idx_32_t56_oppfact_c713_opp_close_date_c705_opp_stagename_start on t56_oppfact t56_oppfact_2 (cost=5.06..77,202.51 rows=14,790 width=28) (actual time=5,950.173..6,046.400 rows=37,194 loops=1)

  • Index Cond: ((c713_opp_close_date >= 20190202) AND (c713_opp_close_date <= 20190503) AND (c705_opp_stagename = cte0_13.c1) AND (start_stamp <= '1572073199999'::bigint) AND (end_stamp > '1572073199999'::bigint))
  • Filter: ((NOT deleted) AND (c703_opp_ownerid IS NOT NULL) AND (NOT (hashed SubPlan 14)))
  • Rows Removed by Filter: 47797
67.          

SubPlan (for Index Scan)

68. 5,936.257 5,936.257 ↓ 275.5 55,107 1

CTE Scan on openwont1ids cte0_11 (cost=0.00..4.00 rows=200 width=4) (actual time=5,915.763..5,936.257 rows=55,107 loops=1)

69. 1.798 7.227 ↓ 65.9 13,187 1

Hash (cost=846.65..846.65 rows=200 width=4) (actual time=7.227..7.227 rows=13,187 loops=1)

  • Buckets: 16384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 592kB
70. 4.322 5.429 ↓ 65.9 13,187 1

HashAggregate (cost=844.65..846.65 rows=200 width=4) (actual time=4.130..5.429 rows=13,187 loops=1)

  • Group Key: cte0_12.c1
71. 1.107 1.107 ↑ 2.8 13,187 1

CTE Scan on docd_cte_1 cte0_12 (cost=0.00..750.80 rows=37,540 width=4) (actual time=0.001..1.107 rows=13,187 loops=1)

72. 0.000 28.244 ↑ 2.0 1 14,122

Append (cost=0.00..0.34 rows=2 width=16) (actual time=0.002..0.002 rows=1 loops=14,122)

73. 0.000 0.000 ↓ 0.0 0 14,122

Seq Scan on t54_clari_conversion_rate t54_clari_conversion_rate_2 (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=14,122)

  • Filter: ((to_iso_code = 'USD'::text) AND (t56_oppfact_2.c701_opp_currency_code = sid) AND (t56_oppfact_2.c713_opp_close_date = rate_date))
74. 28.244 28.244 ↑ 1.0 1 14,122

Index Scan using t54_clari_conversion_rate_usd_sidratedateunique on t54_clari_conversion_rate_usd t54_clari_conversion_rate_usd_2 (cost=0.29..0.34 rows=1 width=16) (actual time=0.001..0.002 rows=1 loops=14,122)

  • Index Cond: ((t56_oppfact_2.c701_opp_currency_code = sid) AND (t56_oppfact_2.c713_opp_close_date = rate_date))
  • Filter: (to_iso_code = 'USD'::text)
75. 28.244 28.244 ↓ 0.0 0 14,122

Index Scan using t56_oppfact_sidendstampunique on t56_oppfact t56_oppfact_3 (cost=0.56..4.52 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=14,122)

  • Index Cond: ((t56_oppfact_2.sid = sid) AND (t56_oppfact_2.sid = sid) AND (end_stamp > '1552719599999'::bigint))
  • Filter: ((NOT deleted) AND (start_stamp <= '1552719599999'::bigint))
  • Rows Removed by Filter: 1
76.          

SubPlan (for Nested Loop Left Join)

77. 0.000 0.000 ↓ 0.0 0

CTE Scan on picklist_5 cte0_9 (cost=0.00..0.04 rows=2 width=4) (never executed)

78. 0.000 0.000 ↓ 0.0 0

CTE Scan on docd_cte_1 cte0_10 (cost=0.00..750.80 rows=37,540 width=4) (never executed)

79. 0.012 6,144.975 ↑ 7,395.0 1 1

Subquery Scan on *SELECT* 1 (cost=0.00..240.34 rows=7,395 width=96) (actual time=6,144.974..6,144.975 rows=1 loops=1)

80. 6,144.963 6,144.963 ↑ 7,395.0 1 1

CTE Scan on bucketd cte0 (cost=0.00..147.90 rows=7,395 width=120) (actual time=6,144.963..6,144.963 rows=1 loops=1)

81. 0.028 30.731 ↑ 816.5 10 1

Hash Left Join (cost=1.11..197.07 rows=8,165 width=72) (actual time=30.690..30.731 rows=10 loops=1)

  • Hash Cond: (cte0_1.c6 = t58_opportunityforecastcategorypicklistdim.sid)
82. 30.690 30.690 ↑ 816.5 10 1

CTE Scan on bucketab cte0_1 (cost=0.00..163.30 rows=8,165 width=68) (actual time=30.651..30.690 rows=10 loops=1)

83. 0.004 0.013 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=12) (actual time=0.013..0.013 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
84. 0.009 0.009 ↑ 1.0 5 1

Seq Scan on t58_opportunityforecastcategorypicklistdim (cost=0.00..1.05 rows=5 width=12) (actual time=0.008..0.009 rows=5 loops=1)

Planning time : 7.440 ms
Execution time : 6,184.086 ms