explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YrV1

Settings
# exclusive inclusive rows x rows loops node
1. 2.162 153.798 ↓ 17.5 4,632 1

HashAggregate (cost=13,007.15..13,009.79 rows=264 width=4) (actual time=153.123..153.798 rows=4,632 loops=1)

  • Group Key: c.header_id
2. 15.440 151.636 ↓ 4.0 4,632 1

Hash Left Join (cost=9,099.52..13,004.28 rows=1,147 width=4) (actual time=131.706..151.636 rows=4,632 loops=1)

  • Hash Cond: (c.platce_id = platce.header_id)
3. 0.612 34.647 ↓ 4.0 4,632 1

Hash Left Join (cost=4,510.12..7,936.68 rows=1,147 width=8) (actual time=29.651..34.647 rows=4,632 loops=1)

  • Hash Cond: (c.platebni_vymer_id = ekopoptss11.header_id)
4. 0.553 33.780 ↓ 4.0 4,632 1

Hash Left Join (cost=4,485.95..7,905.33 rows=1,147 width=12) (actual time=29.393..33.780 rows=4,632 loops=1)

  • Hash Cond: (c.exekuce_id = ekopoptss18.header_id)
5. 0.628 33.226 ↓ 4.0 4,632 1

Hash Left Join (cost=4,473.44..7,888.51 rows=1,147 width=16) (actual time=29.377..33.226 rows=4,632 loops=1)

  • Hash Cond: (c.doklad_pro_ucetnictvi_id = dokladproucetnictvi.header_id)
6. 1.131 29.544 ↓ 4.0 4,632 1

Hash Left Join (cost=3,398.22..6,799.39 rows=1,147 width=20) (actual time=26.293..29.544 rows=4,632 loops=1)

  • Hash Cond: (c.dobropisovano_id = dobropisovano.header_id)
7. 12.556 12.556 ↓ 4.0 4,632 1

Seq Scan on ekopoptss05 c (cost=0.00..3,343.66 rows=1,147 width=24) (actual time=10.222..12.556 rows=4,632 loops=1)

  • Filter: ((plati_do IS NULL) AND (sipo_davka_id = 28))
  • Rows Removed by Filter: 83421
8. 3.886 15.857 ↓ 1.0 22,143 1

Hash (cost=3,123.53..3,123.53 rows=21,975 width=4) (actual time=15.857..15.857 rows=22,143 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1035kB
9. 11.971 11.971 ↓ 1.0 22,143 1

Seq Scan on ekopoptss05 dobropisovano (cost=0.00..3,123.53 rows=21,975 width=4) (actual time=0.008..11.971 rows=22,143 loops=1)

  • Filter: (plati_do IS NULL)
  • Rows Removed by Filter: 65910
10. 0.589 3.054 ↑ 1.0 3,446 1

Hash (cost=1,032.15..1,032.15 rows=3,446 width=4) (actual time=3.054..3.054 rows=3,446 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 154kB
11. 2.465 2.465 ↑ 1.0 3,446 1

Seq Scan on ekojdrtss01 dokladproucetnictvi (cost=0.00..1,032.15 rows=3,446 width=4) (actual time=0.003..2.465 rows=3,446 loops=1)

  • Filter: (plati_do IS NULL)
  • Rows Removed by Filter: 8769
12. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=12.50..12.50 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
13. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on ekopoptss18 (cost=0.00..12.50 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((plati_do IS NULL) AND (class_id = 2))
14. 0.085 0.255 ↑ 1.0 565 1

Hash (cost=17.10..17.10 rows=565 width=4) (actual time=0.255..0.255 rows=565 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
15. 0.170 0.170 ↑ 1.0 565 1

Seq Scan on ekopoptss11 (cost=0.00..17.10 rows=565 width=4) (actual time=0.007..0.170 rows=565 loops=1)

  • Filter: ((plati_do IS NULL) AND (class_id = 1))
  • Rows Removed by Filter: 3
16. 38.700 101.549 ↓ 1.0 115,992 1

Hash (cost=2,686.82..2,686.82 rows=115,967 width=4) (actual time=101.549..101.549 rows=115,992 loops=1)

  • Buckets: 131072 Batches: 2 Memory Usage: 3064kB
17. 62.849 62.849 ↓ 1.0 115,992 1

Seq Scan on jasadrtss10 platce (cost=0.00..2,686.82 rows=115,967 width=4) (actual time=0.038..62.849 rows=115,992 loops=1)

  • Filter: (plati_do IS NULL)
  • Rows Removed by Filter: 4090
Planning time : 4.845 ms
Execution time : 154.743 ms