explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kWOS

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.017 ↓ 0.0 0 1

Update on demo_deals d0 (cost=0.28..8.60 rows=3 width=383) (actual time=0.017..0.017 rows=0 loops=1)

  • Update on demo_deals_y2020_m07_d29 d0_1
  • Update on demo_deals_y2020_m07_d30 d0_2
  • Update on demo_deals_def d0_3
2. 0.011 0.011 ↓ 0.0 0 1

Index Scan using demo_deals_y2020_m07_d29_id_idx1 on demo_deals_y2020_m07_d29 d0_1 (cost=0.28..3.90 rows=1 width=289) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (id = ANY ('{1556573005,1556573018}'::integer[]))
  • Filter: (opened AND (created_at > '2020-07-29 00:00:00'::timestamp without time zone) AND ((status)::text = 'open'::text))
3. 0.002 0.002 ↓ 0.0 0 1

Index Scan using demo_deals_y2020_m07_d30_user_id_status_created_at_idx on demo_deals_y2020_m07_d30 d0_2 (cost=0.12..2.35 rows=1 width=571) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (((status)::text = 'open'::text) AND (created_at > '2020-07-29 00:00:00'::timestamp without time zone))
  • Filter: (opened AND (id = ANY ('{1556573005,1556573018}'::integer[])))
4. 0.002 0.002 ↓ 0.0 0 1

Index Scan using demo_deals_new_def_user_id_status_created_at_idx on demo_deals_def d0_3 (cost=0.12..2.35 rows=1 width=289) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (((status)::text = 'open'::text) AND (created_at > '2020-07-29 00:00:00'::timestamp without time zone))
  • Filter: (opened AND (id = ANY ('{1556573005,1556573018}'::integer[])))
Planning time : 11.209 ms
Execution time : 0.245 ms