explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PwBk

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 0.064 ↓ 0.0 0 1

Hash Semi Join (cost=415,003.02..1,207,142.18 rows=6 width=1,062) (actual time=0.064..0.064 rows=0 loops=1)

  • Hash Cond: (contract_period.contract_definition_id = u0.id)
2. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=414,989.07..1,205,362.68 rows=672,564 width=1,062) (never executed)

  • Hash Cond: (contract_period.kbk_id = kbk.id)
3. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=327,695.57..939,196.70 rows=672,564 width=870) (never executed)

  • Hash Cond: (contract_period.contract_definition_id = contract_definition.id)
4. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=291,532.04..772,557.67 rows=672,564 width=678) (never executed)

  • Hash Cond: (contract_period.kosgu_id = kbk_kosgu.id)
5. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=97,866.04..425,720.19 rows=672,564 width=490) (never executed)

  • Hash Cond: (contract_period.dkr_id = ack_dkr.id)
6. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=60,745.66..312,331.33 rows=672,564 width=358) (never executed)

  • Hash Cond: (contract_period.dfk_id = ack_dfk.id)
7. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=36.05..186,217.24 rows=672,564 width=253) (never executed)

  • Merge Cond: (contract_period.dek_id = ack_dek.id)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using contract_period_dek_id on contract_period (cost=0.42..47,377.80 rows=672,564 width=86) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using ack_dek_pkey on ack_dek (cost=0.43..129,646.68 rows=1,913,550 width=167) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Hash (cost=29,751.05..29,751.05 rows=1,063,805 width=105) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on ack_dfk (cost=0.00..29,751.05 rows=1,063,805 width=105) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Hash (cost=18,344.50..18,344.50 rows=586,150 width=132) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Seq Scan on ack_dkr (cost=0.00..18,344.50 rows=586,150 width=132) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Hash (cost=96,347.67..96,347.67 rows=2,503,867 width=188) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Seq Scan on kbk_kosgu (cost=0.00..96,347.67 rows=2,503,867 width=188) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Hash (cost=16,835.68..16,835.68 rows=497,268 width=192) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on contract_definition (cost=0.00..16,835.68 rows=497,268 width=192) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Hash (cost=43,096.33..43,096.33 rows=1,137,133 width=192) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on kbk (cost=0.00..43,096.33 rows=1,137,133 width=192) (never executed)

20. 0.000 0.038 ↓ 0.0 0 1

Hash (cost=13.94..13.94 rows=1 width=4) (actual time=0.038..0.038 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
21. 0.001 0.038 ↓ 0.0 0 1

Nested Loop (cost=0.84..13.94 rows=1 width=4) (actual time=0.038..0.038 rows=0 loops=1)

22. 0.037 0.037 ↓ 0.0 0 1

Index Scan using contract_definition_info_date_next on contract_definition u0 (cost=0.42..5.34 rows=1 width=8) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: (info_date_next >= '9999-12-31 23:59:59'::timestamp without time zone)
  • Filter: ((contract_id = ANY ('{415853,465614}'::integer[])) AND (date_formatting >= '2019-01-01'::date) AND (date_formatting <= '2019-12-31'::date) AND (info_date <= '9999-12-31 23:59:59'::timestamp without time zone))
23. 0.000 0.000 ↓ 0.0 0

Index Scan using contract_pkey on contract u1 (cost=0.42..8.44 rows=1 width=4) (never executed)

  • Index Cond: (id = u0.contract_id)
  • Filter: (ent_id = 2,106)
Planning time : 4,598.871 ms
Execution time : 51.045 ms