explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GWtu

Settings
# exclusive inclusive rows x rows loops node
1. 11.147 11,448.636 ↓ 4,632.0 4,632 1

HashAggregate (cost=8,133.51..8,133.52 rows=1 width=4) (actual time=11,447.707..11,448.636 rows=4,632 loops=1)

  • Group Key: c.header_id
2. 184.944 11,437.489 ↓ 4,632.0 4,632 1

Nested Loop Left Join (cost=3,552.09..8,133.51 rows=1 width=4) (actual time=35.592..11,437.489 rows=4,632 loops=1)

  • Join Filter: (ekopoptss11.header_id = c.platebni_vymer_id)
  • Rows Removed by Join Filter: 2617080
3. 8.942 10,474.369 ↓ 4,632.0 4,632 1

Nested Loop Left Join (cost=3,552.09..8,109.34 rows=1 width=8) (actual time=35.399..10,474.369 rows=4,632 loops=1)

4. 52.244 10,446.899 ↓ 4,632.0 4,632 1

Nested Loop Left Join (cost=3,551.68..8,100.90 rows=1 width=12) (actual time=35.383..10,446.899 rows=4,632 loops=1)

  • Join Filter: (ekopoptss18.header_id = c.exekuce_id)
5. 1,427.769 10,394.655 ↓ 4,632.0 4,632 1

Nested Loop Left Join (cost=3,551.68..8,088.39 rows=1 width=16) (actual time=35.373..10,394.655 rows=4,632 loops=1)

  • Join Filter: (dokladproucetnictvi.header_id = c.doklad_pro_ucetnictvi_id)
  • Rows Removed by Join Filter: 15961872
6. 5.493 36.390 ↓ 4,632.0 4,632 1

Hash Right Join (cost=3,551.68..6,965.41 rows=1 width=20) (actual time=33.147..36.390 rows=4,632 loops=1)

  • Hash Cond: (dobropisovano.header_id = c.dobropisovano_id)
7. 10.481 10.481 ↓ 1.0 22,143 1

Seq Scan on ekopoptss05 dobropisovano (cost=0.00..3,331.53 rows=21,919 width=4) (actual time=0.002..10.481 rows=22,143 loops=1)

  • Filter: (plati_do IS NULL)
  • Rows Removed by Filter: 65910
8. 0.806 20.416 ↓ 4,632.0 4,632 1

Hash (cost=3,551.66..3,551.66 rows=1 width=24) (actual time=20.416..20.416 rows=4,632 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 233kB
9. 19.610 19.610 ↓ 4,632.0 4,632 1

Seq Scan on ekopoptss05 c (cost=0.00..3,551.66 rows=1 width=24) (actual time=16.989..19.610 rows=4,632 loops=1)

  • Filter: ((plati_do IS NULL) AND (sipo_davka_id = 28))
  • Rows Removed by Filter: 83421
10. 8,930.496 8,930.496 ↑ 1.3 3,446 4,632

Seq Scan on ekojdrtss01 dokladproucetnictvi (cost=0.00..1,067.45 rows=4,442 width=4) (actual time=0.002..1.928 rows=3,446 loops=4,632)

  • Filter: (plati_do IS NULL)
  • Rows Removed by Filter: 8769
11. 0.000 0.000 ↓ 0.0 0 4,632

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

  • Filter: ((plati_do IS NULL) AND (class_id = 2))
12. 18.528 18.528 ↓ 0.0 0 4,632

Index Scan using ix_jasadrtss10_header_id on jasadrtss10 platce (cost=0.42..8.44 rows=1 width=4) (actual time=0.003..0.004 rows=0 loops=4,632)

  • Index Cond: (header_id = c.platce_id)
  • Filter: (plati_do IS NULL)
13. 778.176 778.176 ↑ 1.0 565 4,632

Seq Scan on ekopoptss11 (cost=0.00..17.10 rows=565 width=4) (actual time=0.004..0.168 rows=565 loops=4,632)

  • Filter: ((plati_do IS NULL) AND (class_id = 1))
  • Rows Removed by Filter: 3
Planning time : 2.163 ms
Execution time : 11,449.152 ms