explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ueoA

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 31,858.567 ↑ 1.0 1 1

Limit (cost=0.43..48.83 rows=1 width=8) (actual time=31,858.566..31,858.567 rows=1 loops=1)

2. 31,858.563 31,858.563 ↑ 6,836.0 1 1

Index Scan using kbk_kosgu_parent_id on kbk_kosgu (cost=0.43..330,861.27 rows=6,836 width=8) (actual time=31,858.563..31,858.563 rows=1 loops=1)

  • Filter: ((begin <= '2019-03-20'::date) AND ("end" >= '2019-03-20'::date) AND (state = 0) AND ((code)::text = '341'::text))
  • Rows Removed by Filter: 1211617