explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nfEV

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1,927.560 ↑ 1.0 1 1

Limit (cost=0.43..48.37 rows=1 width=8) (actual time=1,927.558..1,927.560 rows=1 loops=1)

2. 1,927.555 1,927.555 ↑ 6,938.0 1 1

Index Scan using kbk_kosgu_parent_id on kbk_kosgu (cost=0.43..332,576.97 rows=6,938 width=8) (actual time=1,927.555..1,927.555 rows=1 loops=1)

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