explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FGex

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.020 ↑ 19.0 2 1

Append (cost=0.43..250.29 rows=38 width=301) (actual time=0.010..0.020 rows=2 loops=1)

2. 0.013 0.013 ↑ 3.0 1 1

Index Scan using professional_events_201906_professional_id_idx on professional_events_201906 (cost=0.43..84.83 rows=3 width=305) (actual time=0.010..0.013 rows=1 loops=1)

  • Index Cond: (professional_id = 60822068)
  • Filter: ((occurred_at >= '2019-06-28 00:00:00'::timestamp without time zone) AND (occurred_at <= '2019-07-28 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3
3. 0.006 0.006 ↑ 35.0 1 1

Index Scan using professional_events_201907_professional_id_idx on professional_events_201907 (cost=0.44..165.28 rows=35 width=301) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (professional_id = 60822068)
  • Filter: ((occurred_at >= '2019-06-28 00:00:00'::timestamp without time zone) AND (occurred_at <= '2019-07-28 00:00:00'::timestamp without time zone))
Planning time : 0.197 ms
Execution time : 0.039 ms