explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ImjDa

Settings
# exclusive inclusive rows x rows loops node
1. 0.378 5,838.659 ↑ 1.0 25 1

Limit (cost=338,373.23..338,373.54 rows=25 width=1,149) (actual time=5,838.282..5,838.659 rows=25 loops=1)

2. 158.877 5,838.281 ↑ 6,813.0 25 1

Sort (cost=338,373.23..338,799.04 rows=170,325 width=1,149) (actual time=5,838.280..5,838.281 rows=25 loops=1)

  • Sort Key: uokcnnn1uify6vxqq_5.eknughqdlfmxqsb7b, uokcnnn1uify6vxqq.eknughqdlfmxqsb7b NULLS FIRST
  • Sort Method: top-N heapsort Memory: 36kB
3. 356.613 5,679.404 ↓ 1.1 181,118 1

Hash Join (cost=196,670.56..268,559.00 rows=170,325 width=1,149) (actual time=2,034.512..5,679.404 rows=181,118 loops=1)

  • Hash Cond: (fpycf7fsyxfssfikx.ingredient_kcme5kebtu6evjxm = uokcnnn1uify6vxqq.xki8trxbqp6crggmo)
4. 187.590 5,310.697 ↓ 1.1 181,118 1

Hash Join (cost=195,413.72..266,003.35 rows=170,325 width=599) (actual time=2,022.323..5,310.697 rows=181,118 loops=1)

  • Hash Cond: (fpycf7fsyxfssfikx_6.idnewtable_xdetefigyduum1vy = fpycf7fsyxfssfikx.idnewtable_xdetefigyduum1vy)
5. 178.660 5,009.527 ↓ 1.0 181,118 1

Merge Join (cost=186,305.19..256,437.26 rows=174,300 width=559) (actual time=1,908.251..5,009.527 rows=181,118 loops=1)

  • Merge Cond: (fpycf7fsyxfssfikx_1.idnewtable_xdetefigyduum1vy = fpycf7fsyxfssfikx_6.idnewtable_xdetefigyduum1vy)
6. 1,580.379 4,521.926 ↓ 1.0 186,260 1

Merge Left Join (cost=162,573.94..225,584.63 rows=186,250 width=5,210) (actual time=1,708.393..4,521.926 rows=186,260 loops=1)

  • Merge Cond: (fpycf7fsyxfssfikx_1.idnewtable_xdetefigyduum1vy = fpycf7fsyxfssfikx_3.idnewtable_xdetefigyduum1vy)
7. 183.286 1,178.642 ↓ 1.0 186,260 1

Sort (cost=80,216.47..80,682.10 rows=186,250 width=187) (actual time=1,116.627..1,178.642 rows=186,260 loops=1)

  • Sort Key: fpycf7fsyxfssfikx_1.idnewtable_xdetefigyduum1vy DESC NULLS LAST
  • Sort Method: quicksort Memory: 51737kB
8. 71.384 995.356 ↓ 1.0 186,260 1

Hash Left Join (cost=53,540.95..63,913.19 rows=186,250 width=187) (actual time=673.211..995.356 rows=186,260 loops=1)

  • Hash Cond: (fpycf7fsyxfssfikx_1.ingredient_kcme5kebtu6evjxm = fgvup5cpnje7dqelm.xki8trxbqp6crggmo)
9. 64.362 901.843 ↓ 1.0 186,260 1

Hash Left Join (cost=50,565.48..58,376.90 rows=186,250 width=178) (actual time=650.891..901.843 rows=186,260 loops=1)

  • Hash Cond: (fpycf7fsyxfssfikx_1.product_17ogkvlhjmg5lxru = uokcnnn1uify6vxqq_1.xki8trxbqp6crggmo)
10. 153.809 826.078 ↓ 1.0 186,260 1

Hash Left Join (cost=49,308.65..56,631.06 rows=186,250 width=169) (actual time=639.293..826.078 rows=186,260 loops=1)

  • Hash Cond: (fpycf7fsyxfssfikx_1.idnewtable_xdetefigyduum1vy = dtutwcqa9jehc4luz.idnewtable_xdetefigyduum1vy)
11. 33.466 33.466 ↓ 1.0 186,260 1

Seq Scan on fpycf7fsyxfssfikx fpycf7fsyxfssfikx_1 (cost=0.00..6,833.50 rows=186,250 width=50) (actual time=0.015..33.466 rows=186,260 loops=1)

12. 65.952 638.803 ↑ 1.0 155,510 1

Hash (cost=47,268.63..47,268.63 rows=163,201 width=123) (actual time=638.803..638.803 rows=155,510 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 26056kB
13. 55.857 572.851 ↑ 1.0 155,510 1

Subquery Scan on dtutwcqa9jehc4luz (cost=44,820.62..47,268.63 rows=163,201 width=123) (actual time=378.657..572.851 rows=155,510 loops=1)

14. 109.622 516.994 ↑ 1.0 155,510 1

Unique (cost=44,820.62..45,636.62 rows=163,201 width=139) (actual time=378.654..516.994 rows=155,510 loops=1)

15. 132.064 407.372 ↓ 1.0 164,213 1

Sort (cost=44,820.62..45,228.62 rows=163,201 width=139) (actual time=378.649..407.372 rows=164,213 loops=1)

  • Sort Key: fpycf7fsyxfssfikx_2.idnewtable_xdetefigyduum1vy, y8szoykbf6dc2hk7m.creationtimeauto_2qvu84khhwt2ne0g DESC NULLS LAST
  • Sort Method: quicksort Memory: 49480kB
16. 149.314 275.308 ↓ 1.0 164,213 1

Hash Join (cost=9,161.62..30,690.44 rows=163,201 width=139) (actual time=77.737..275.308 rows=164,213 loops=1)

  • Hash Cond: (y8szoykbf6dc2hk7m.in_id_63ohqrodibhrvfw1 = fpycf7fsyxfssfikx_2.idnewtable_xdetefigyduum1vy)
17. 48.731 48.731 ↓ 1.0 369,197 1

Seq Scan on y8szoykbf6dc2hk7m (cost=0.00..20,566.17 rows=366,717 width=131) (actual time=0.010..48.731 rows=369,197 loops=1)

18. 32.997 77.263 ↓ 1.0 186,260 1

Hash (cost=6,833.50..6,833.50 rows=186,250 width=4) (actual time=77.262..77.263 rows=186,260 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 8597kB
19. 44.266 44.266 ↓ 1.0 186,260 1

Seq Scan on fpycf7fsyxfssfikx fpycf7fsyxfssfikx_2 (cost=0.00..6,833.50 rows=186,250 width=4) (actual time=0.006..44.266 rows=186,260 loops=1)

20. 3.983 11.403 ↑ 1.0 20,437 1

Hash (cost=1,001.37..1,001.37 rows=20,437 width=13) (actual time=11.403..11.403 rows=20,437 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1158kB
21. 7.420 7.420 ↑ 1.0 20,437 1

Seq Scan on uokcnnn1uify6vxqq uokcnnn1uify6vxqq_1 (cost=0.00..1,001.37 rows=20,437 width=13) (actual time=0.024..7.420 rows=20,437 loops=1)

22. 3.382 22.129 ↑ 1.0 20,437 1

Hash (cost=2,720.01..2,720.01 rows=20,437 width=13) (actual time=22.129..22.129 rows=20,437 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1158kB
23. 2.819 18.747 ↑ 1.0 20,437 1

Subquery Scan on fgvup5cpnje7dqelm (cost=2,464.55..2,720.01 rows=20,437 width=13) (actual time=14.496..18.747 rows=20,437 loops=1)

24. 7.912 15.928 ↑ 1.0 20,437 1

Sort (cost=2,464.55..2,515.64 rows=20,437 width=2,116) (actual time=14.495..15.928 rows=20,437 loops=1)

  • Sort Key: uokcnnn1uify6vxqq_2.bfmoqqxskrbewwu2h DESC NULLS LAST
  • Sort Method: quicksort Memory: 2353kB
25. 8.016 8.016 ↑ 1.0 20,437 1

Seq Scan on uokcnnn1uify6vxqq uokcnnn1uify6vxqq_2 (cost=0.00..1,001.37 rows=20,437 width=2,116) (actual time=0.007..8.016 rows=20,437 loops=1)

26. 43.738 1,762.905 ↑ 1.0 181,766 1

Materialize (cost=82,352.38..133,785.76 rows=182,003 width=12) (actual time=591.754..1,762.905 rows=181,766 loops=1)

27. 1,047.305 1,719.167 ↑ 1.0 181,766 1

Merge Left Join (cost=82,352.38..131,510.72 rows=182,003 width=1,060) (actual time=591.746..1,719.167 rows=181,766 loops=1)

  • Merge Cond: (fpycf7fsyxfssfikx_3.idnewtable_xdetefigyduum1vy = fpycf7fsyxfssfikx_4.idnewtable_xdetefigyduum1vy)
28. 113.082 173.680 ↑ 1.0 181,766 1

Sort (cost=22,734.74..23,189.75 rows=182,003 width=16) (actual time=124.895..173.680 rows=181,766 loops=1)

  • Sort Key: fpycf7fsyxfssfikx_3.idnewtable_xdetefigyduum1vy DESC NULLS LAST
  • Sort Method: quicksort Memory: 20342kB
29. 60.598 60.598 ↑ 1.0 181,766 1

Seq Scan on fpycf7fsyxfssfikx fpycf7fsyxfssfikx_3 (cost=0.00..6,833.50 rows=182,003 width=16) (actual time=0.022..60.598 rows=181,766 loops=1)

  • Filter: (NOT removeingredient_f0aln7tbplfxzjtr)
  • Rows Removed by Filter: 4494
30. 71.108 498.182 ↓ 1.2 186,260 1

Sort (cost=59,617.55..60,005.57 rows=155,208 width=12) (actual time=466.689..498.182 rows=186,260 loops=1)

  • Sort Key: fpycf7fsyxfssfikx_4.idnewtable_xdetefigyduum1vy DESC NULLS LAST
  • Sort Method: quicksort Memory: 14875kB
31. 43.237 427.074 ↓ 1.2 186,260 1

Hash Left Join (cost=26,167.27..46,235.64 rows=155,208 width=12) (actual time=251.447..427.074 rows=186,260 loops=1)

  • Hash Cond: (uokcnnn1uify6vxqq_3.xki8trxbqp6crggmo = k3bwjcois1qwlosxe.xki8trxbqp6crggmo)
32. 0.000 214.360 ↓ 1.2 186,260 1

Gather Merge (cost=14,510.59..32,619.45 rows=155,208 width=1,561) (actual time=81.894..214.360 rows=186,260 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
33. 102.921 263.238 ↑ 1.2 62,087 3

Sort (cost=13,510.57..13,704.58 rows=77,604 width=1,561) (actual time=74.065..87.746 rows=62,087 loops=3)

  • Sort Key: fpycf7fsyxfssfikx_4.idnewtable_xdetefigyduum1vy DESC NULLS LAST
  • Sort Method: quicksort Memory: 6574kB
34. 76.374 160.317 ↑ 1.2 62,087 3

Hash Left Join (cost=1,256.83..7,207.63 rows=77,604 width=1,561) (actual time=13.540..53.439 rows=62,087 loops=3)

  • Hash Cond: (fpycf7fsyxfssfikx_4.product_17ogkvlhjmg5lxru = uokcnnn1uify6vxqq_3.xki8trxbqp6crggmo)
35. 44.268 44.268 ↑ 1.2 62,087 3

Parallel Seq Scan on fpycf7fsyxfssfikx fpycf7fsyxfssfikx_4 (cost=0.00..5,747.04 rows=77,604 width=8) (actual time=0.040..14.756 rows=62,087 loops=3)

36. 10.053 39.675 ↑ 1.0 20,437 3

Hash (cost=1,001.37..1,001.37 rows=20,437 width=8) (actual time=13.225..13.225 rows=20,437 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 975kB
37. 29.622 29.622 ↑ 1.0 20,437 3

Seq Scan on uokcnnn1uify6vxqq uokcnnn1uify6vxqq_3 (cost=0.00..1,001.37 rows=20,437 width=8) (actual time=0.023..9.874 rows=20,437 loops=3)

38. 2.893 169.477 ↑ 1.3 16,212 1

Hash (cost=11,401.21..11,401.21 rows=20,437 width=12) (actual time=169.477..169.477 rows=16,212 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 953kB
39. 2.363 166.584 ↑ 1.3 16,212 1

Subquery Scan on k3bwjcois1qwlosxe (cost=11,145.75..11,401.21 rows=20,437 width=12) (actual time=162.749..166.584 rows=16,212 loops=1)

40. 6.094 164.221 ↑ 1.3 16,212 1

Sort (cost=11,145.75..11,196.84 rows=20,437 width=12) (actual time=162.746..164.221 rows=16,212 loops=1)

  • Sort Key: uokcnnn1uify6vxqq_4.xki8trxbqp6crggmo DESC NULLS LAST
  • Sort Method: quicksort Memory: 1144kB
41. 45.871 158.127 ↑ 1.3 16,212 1

HashAggregate (cost=9,478.21..9,682.58 rows=20,437 width=12) (actual time=154.479..158.127 rows=16,212 loops=1)

  • Group Key: uokcnnn1uify6vxqq_4.xki8trxbqp6crggmo
42. 42.197 112.256 ↑ 1.0 181,758 1

Hash Join (cost=1,256.83..8,568.19 rows=182,003 width=12) (actual time=8.662..112.256 rows=181,758 loops=1)

  • Hash Cond: (fpycf7fsyxfssfikx_5.product_17ogkvlhjmg5lxru = uokcnnn1uify6vxqq_4.xki8trxbqp6crggmo)
43. 61.477 61.477 ↑ 1.0 181,766 1

Seq Scan on fpycf7fsyxfssfikx fpycf7fsyxfssfikx_5 (cost=0.00..6,833.50 rows=182,003 width=12) (actual time=0.019..61.477 rows=181,766 loops=1)

  • Filter: (NOT removeingredient_f0aln7tbplfxzjtr)
  • Rows Removed by Filter: 4494
44. 2.773 8.582 ↑ 1.0 20,437 1

Hash (cost=1,001.37..1,001.37 rows=20,437 width=4) (actual time=8.582..8.582 rows=20,437 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 975kB
45. 5.809 5.809 ↑ 1.0 20,437 1

Seq Scan on uokcnnn1uify6vxqq uokcnnn1uify6vxqq_4 (cost=0.00..1,001.37 rows=20,437 width=4) (actual time=0.023..5.809 rows=20,437 loops=1)

46. 51.294 308.941 ↓ 1.0 181,118 1

Materialize (cost=23,731.25..26,345.75 rows=174,300 width=39) (actual time=199.851..308.941 rows=181,118 loops=1)

47. 130.551 257.647 ↓ 1.0 181,118 1

Sort (cost=23,731.25..24,167.00 rows=174,300 width=39) (actual time=199.845..257.647 rows=181,118 loops=1)

  • Sort Key: fpycf7fsyxfssfikx_6.idnewtable_xdetefigyduum1vy DESC NULLS LAST
  • Sort Method: quicksort Memory: 22417kB
48. 50.616 127.096 ↓ 1.0 181,118 1

Hash Join (cost=1,246.02..8,557.38 rows=174,300 width=39) (actual time=16.002..127.096 rows=181,118 loops=1)

  • Hash Cond: (fpycf7fsyxfssfikx_6.product_17ogkvlhjmg5lxru = uokcnnn1uify6vxqq_5.xki8trxbqp6crggmo)
49. 60.566 60.566 ↑ 1.0 181,766 1

Seq Scan on fpycf7fsyxfssfikx fpycf7fsyxfssfikx_6 (cost=0.00..6,833.50 rows=182,003 width=8) (actual time=0.023..60.566 rows=181,766 loops=1)

  • Filter: (NOT removeingredient_f0aln7tbplfxzjtr)
  • Rows Removed by Filter: 4494
50. 4.132 15.914 ↓ 1.0 19,942 1

Hash (cost=1,001.37..1,001.37 rows=19,572 width=39) (actual time=15.914..15.914 rows=19,942 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1691kB
51. 11.782 11.782 ↓ 1.0 19,942 1

Seq Scan on uokcnnn1uify6vxqq uokcnnn1uify6vxqq_5 (cost=0.00..1,001.37 rows=19,572 width=39) (actual time=0.010..11.782 rows=19,942 loops=1)

  • Filter: ((eknughqdlfmxqsb7b IS NOT NULL) AND (NOT wtbk4nwixck9rlijf) AND (eknughqdlfmxqsb7b IS NOT NULL))
  • Rows Removed by Filter: 495
52. 47.532 113.580 ↑ 1.0 181,766 1

Hash (cost=6,833.50..6,833.50 rows=182,003 width=48) (actual time=113.580..113.580 rows=181,766 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 16964kB
53. 66.048 66.048 ↑ 1.0 181,766 1

Seq Scan on fpycf7fsyxfssfikx (cost=0.00..6,833.50 rows=182,003 width=48) (actual time=0.018..66.048 rows=181,766 loops=1)

  • Filter: (NOT removeingredient_f0aln7tbplfxzjtr)
  • Rows Removed by Filter: 4494
54. 4.060 12.094 ↑ 1.0 20,437 1

Hash (cost=1,001.37..1,001.37 rows=20,437 width=38) (actual time=12.094..12.094 rows=20,437 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1700kB
55. 8.034 8.034 ↑ 1.0 20,437 1

Seq Scan on uokcnnn1uify6vxqq (cost=0.00..1,001.37 rows=20,437 width=38) (actual time=0.016..8.034 rows=20,437 loops=1)

Planning time : 4.141 ms
Execution time : 5,843.159 ms