explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8HQ0

Settings
# exclusive inclusive rows x rows loops node
1. 0.450 16.944 ↓ 2.9 2,302 1

Unique (cost=40,135.35..40,156.68 rows=793 width=36) (actual time=16.393..16.944 rows=2,302 loops=1)

2. 1.038 16.494 ↓ 1.3 2,861 1

Sort (cost=40,135.35..40,140.69 rows=2,133 width=36) (actual time=16.392..16.494 rows=2,861 loops=1)

  • Sort Key: prp2.prp_id, arh."DateValue
  • Sort Method: quicksort Memory: 320kB
3. 0.546 15.456 ↓ 1.3 2,861 1

Hash Left Join (cost=452.48..40,017.41 rows=2,133 width=36) (actual time=0.142..15.456 rows=2,861 loops=1)

  • Hash Cond: (arangmetrol3.range_id = arang033.range_id)
4. 0.460 14.908 ↓ 1.3 2,861 1

Hash Left Join (cost=451.43..40,008.25 rows=2,133 width=36) (actual time=0.137..14.908 rows=2,861 loops=1)

  • Hash Cond: (aranguser3.range_id = arang023.range_id)
5. 0.531 14.446 ↓ 1.3 2,861 1

Hash Left Join (cost=450.38..39,999.09 rows=2,133 width=36) (actual time=0.130..14.446 rows=2,861 loops=1)

  • Hash Cond: (arangcontract3.range_id = arang013.range_id)
6. 0.375 13.907 ↓ 1.3 2,861 1

Merge Left Join (cost=449.33..39,989.94 rows=2,133 width=36) (actual time=0.099..13.907 rows=2,861 loops=1)

  • Merge Cond: (arh.pr_id = arangmetrol3.prp_id)
7. 0.391 13.528 ↓ 1.3 2,861 1

Merge Left Join (cost=299.56..39,806.45 rows=2,133 width=36) (actual time=0.093..13.528 rows=2,861 loops=1)

  • Merge Cond: (arh.pr_id = aranguser3.prp_id)
8. 0.341 13.132 ↓ 1.3 2,861 1

Merge Left Join (cost=149.78..39,622.97 rows=2,133 width=32) (actual time=0.087..13.132 rows=2,861 loops=1)

  • Merge Cond: (arh.pr_id = arangcontract3.prp_id)
9. 2.337 12.759 ↓ 1.3 2,861 1

Nested Loop (cost=0.00..39,439.49 rows=2,133 width=28) (actual time=0.053..12.759 rows=2,861 loops=1)

10. 0.892 0.892 ↑ 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.030..0.892 rows=4,765 loops=1)

11. 9.530 9.530 ↑ 1.0 1 4,765

Index Scan using "Arhiv_cnt_pr_id_DateValue_typ_arh_idx" on "Arhiv_cnt" arh (cost=0.00..8.23 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=4,765)

  • Index Cond: ((pr_id = prp2.prp_id) AND ("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))
12. 0.020 0.032 ↓ 0.0 0 1

Sort (cost=149.78..155.13 rows=2,140 width=8) (actual time=0.032..0.032 rows=0 loops=1)

  • Sort Key: arangcontract3.prp_id
  • Sort Method: quicksort Memory: 25kB
13. 0.012 0.012 ↓ 0.0 0 1

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

14. 0.005 0.005 ↓ 0.0 0 1

Sort (cost=149.78..155.13 rows=2,140 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Sort Key: aranguser3.prp_id
  • Sort Method: quicksort Memory: 25kB
15. 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)

16. 0.004 0.004 ↓ 0.0 0 1

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

  • Sort Key: arangmetrol3.prp_id
  • Sort Method: quicksort Memory: 25kB
17. 0.000 0.000 ↓ 0.0 0 1

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

18. 0.002 0.008 ↑ 1.0 1 1

Hash (cost=1.04..1.04 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
19. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on "AnalyticRanges" arang013 (cost=0.00..1.04 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=1)

  • Filter: (range_typ = 0)
20. 0.000 0.002 ↑ 1.0 1 1

Hash (cost=1.04..1.04 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
21. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on "AnalyticRanges" arang023 (cost=0.00..1.04 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

  • Filter: (range_typ = 1)
22. 0.000 0.002 ↑ 1.0 1 1

Hash (cost=1.04..1.04 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
23. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on "AnalyticRanges" arang033 (cost=0.00..1.04 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

  • Filter: (range_typ = 2)