explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pcq5 : 2

Settings
# exclusive inclusive rows x rows loops node
1. 5.970 777.167 ↑ 1.1 15,681 1

Unique (cost=105,494.06..105,930.49 rows=16,663 width=36) (actual time=764.589..777.167 rows=15,681 loops=1)

2. 52.284 771.197 ↓ 1.1 49,190 1

Sort (cost=105,494.06..105,603.17 rows=43,643 width=36) (actual time=764.587..771.197 rows=49,190 loops=1)

  • Sort Key: prp2.prp_id, arh."DateValue
  • Sort Method: external sort Disk: 1832kB
3. 7.979 718.913 ↓ 1.1 49,190 1

Merge Right Join (cost=98,279.63..100,937.11 rows=43,643 width=36) (actual time=659.842..718.913 rows=49,190 loops=1)

  • Merge Cond: (arangcontract3.prp_id = arh.pr_id)
4. 0.004 0.006 ↓ 0.0 0 1

Sort (cost=158.96..164.31 rows=2,140 width=8) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: arangcontract3.prp_id
  • Sort Method: quicksort Memory: 25kB
5. 0.001 0.002 ↓ 0.0 0 1

Hash Left Join (cost=1.05..40.58 rows=2,140 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: (arangcontract3.range_id = arang013.range_id)
6. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on "RangesToParam" arangcontract3 (cost=0.00..31.40 rows=2,140 width=8) (actual time=0.001..0.001 rows=0 loops=1)

7. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.04..1.04 rows=1 width=4) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Seq Scan on "AnalyticRanges" arang013 (cost=0.00..1.04 rows=1 width=4) (never executed)

  • Filter: (range_typ = 0)
9. 8.342 710.928 ↓ 1.1 49,190 1

Materialize (cost=98,120.67..100,343.34 rows=43,643 width=36) (actual time=659.835..710.928 rows=49,190 loops=1)

10. 8.169 702.586 ↓ 1.1 49,190 1

Merge Join (cost=98,120.67..100,234.24 rows=43,643 width=36) (actual time=659.831..702.586 rows=49,190 loops=1)

  • Merge Cond: (prp2.prp_id = arh.pr_id)
11. 1.003 1.003 ↑ 1.0 4,765 1

Index Scan using "ParamResPlc_cnt_pkey" on "ParamResPlc_cnt" prp2 (cost=0.00..174.73 rows=4,765 width=4) (actual time=0.009..1.003 rows=4,765 loops=1)

12. 7.909 693.414 ↓ 1.1 49,190 1

Materialize (cost=98,120.67..99,502.10 rows=43,643 width=32) (actual time=659.819..693.414 rows=49,190 loops=1)

13. 5.387 685.505 ↓ 1.1 49,190 1

Merge Left Join (cost=98,120.67..99,392.99 rows=43,643 width=32) (actual time=659.814..685.505 rows=49,190 loops=1)

  • Merge Cond: (arh.pr_id = aranguser3.prp_id)
14. 7.053 680.114 ↓ 1.1 49,190 1

Merge Left Join (cost=97,961.70..98,652.42 rows=43,643 width=28) (actual time=659.808..680.114 rows=49,190 loops=1)

  • Merge Cond: (arh.pr_id = arangmetrol3.prp_id)
15. 65.208 673.046 ↓ 1.1 49,190 1

Sort (cost=97,802.74..97,911.85 rows=43,643 width=24) (actual time=659.789..673.046 rows=49,190 loops=1)

  • Sort Key: arh.pr_id
  • Sort Method: external merge Disk: 1816kB
16. 607.838 607.838 ↓ 1.1 49,190 1

Seq Scan on "Arhiv_cnt" arh (cost=0.00..93,543.29 rows=43,643 width=24) (actual time=571.816..607.838 rows=49,190 loops=1)

  • Filter: (("DateValue" >= '2019-06-24 00:00:00'::timestamp without time zone) AND ("DateValue" <= '2019-07-01 00:00:00'::timestamp without time zone) AND (typ_arh = 2))
17. 0.013 0.015 ↓ 0.0 0 1

Sort (cost=158.96..164.31 rows=2,140 width=8) (actual time=0.015..0.015 rows=0 loops=1)

  • Sort Key: arangmetrol3.prp_id
  • Sort Method: quicksort Memory: 25kB
18. 0.001 0.002 ↓ 0.0 0 1

Hash Left Join (cost=1.05..40.58 rows=2,140 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: (arangmetrol3.range_id = arang033.range_id)
19. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on "RangesToParam" arangmetrol3 (cost=0.00..31.40 rows=2,140 width=8) (actual time=0.001..0.001 rows=0 loops=1)

20. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.04..1.04 rows=1 width=4) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Seq Scan on "AnalyticRanges" arang033 (cost=0.00..1.04 rows=1 width=4) (never executed)

  • Filter: (range_typ = 2)
22. 0.003 0.004 ↓ 0.0 0 1

Sort (cost=158.96..164.31 rows=2,140 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Sort Key: aranguser3.prp_id
  • Sort Method: quicksort Memory: 25kB
23. 0.001 0.001 ↓ 0.0 0 1

Hash Left Join (cost=1.05..40.58 rows=2,140 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Hash Cond: (aranguser3.range_id = arang023.range_id)
24. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on "RangesToParam" aranguser3 (cost=0.00..31.40 rows=2,140 width=8) (actual time=0.000..0.000 rows=0 loops=1)

25. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.04..1.04 rows=1 width=4) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Seq Scan on "AnalyticRanges" arang023 (cost=0.00..1.04 rows=1 width=4) (never executed)

  • Filter: (range_typ = 1)