explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fGMO

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.016 ↓ 0.0 0 1

Limit (cost=0.00..4.29 rows=1 width=317) (actual time=0.016..0.016 rows=0 loops=1)

2. 0.000 0.016 ↓ 0.0 0 1

Append (cost=0.00..8.58 rows=2 width=317) (actual time=0.016..0.016 rows=0 loops=1)

3. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on processed_feed_data_keys (cost=0.00..0.00 rows=1 width=516) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((db_category <> 'DU'::bpchar) AND (run_id = '187631'::bigint) AND (dataset_source_id = 1) AND (effective_begin_date = '2019-10-25'::date))
4. 0.013 0.013 ↓ 0.0 0 1

Index Scan using idx_data_keys_runid_dcat_2019_10_1 on processed_feed_data_keys_2019_10_1 (cost=0.56..8.58 rows=1 width=118) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (run_id = '187631'::bigint)
  • Filter: ((db_category <> 'DU'::bpchar) AND (dataset_source_id = 1) AND (effective_begin_date = '2019-10-25'::date))
Execution time : 0.098 ms