explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aHmL

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.094 ↑ 3.7 6 1

Sort (cost=15.81..15.87 rows=22 width=642) (actual time=0.093..0.094 rows=6 loops=1)

  • Sort Key: eld.event_time
  • Sort Method: quicksort Memory: 28kB
2. 0.001 0.087 ↑ 3.7 6 1

Append (cost=0.00..15.32 rows=22 width=642) (actual time=0.032..0.087 rows=6 loops=1)

3. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on eld_event eld (cost=0.00..0.00 rows=1 width=180) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: ((customer_id = ANY ('{1042463574}'::oid[])) AND (event_time >= '2020-05-20 03:14:15.143035'::timestamp without time zone) AND (event_time < '2020-06-26 03:14:15.143035'::timestamp without time zone))
4. 0.017 0.017 ↑ 1.0 1 1

Index Scan using eld_event_customer_id_idx_202022 on eld_event_202022 eld_1 (cost=0.42..2.45 rows=1 width=655) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: (customer_id = ANY ('{1042463574}'::oid[]))
  • Filter: ((event_time >= '2020-05-20 03:14:15.143035'::timestamp without time zone) AND (event_time < '2020-06-26 03:14:15.143035'::timestamp without time zone))
5. 0.010 0.010 ↓ 0.0 0 1

Index Scan using eld_event_customer_id_idx_202023 on eld_event_202023 eld_2 (cost=0.43..2.44 rows=1 width=660) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (customer_id = ANY ('{1042463574}'::oid[]))
  • Filter: ((event_time >= '2020-05-20 03:14:15.143035'::timestamp without time zone) AND (event_time < '2020-06-26 03:14:15.143035'::timestamp without time zone))
6. 0.011 0.011 ↑ 6.0 1 1

Index Scan using eld_event_customer_id_idx_202021 on eld_event_202021 eld_3 (cost=0.43..2.75 rows=6 width=666) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (customer_id = ANY ('{1042463574}'::oid[]))
  • Filter: ((event_time >= '2020-05-20 03:14:15.143035'::timestamp without time zone) AND (event_time < '2020-06-26 03:14:15.143035'::timestamp without time zone))
7. 0.009 0.009 ↓ 0.0 0 1

Index Scan using eld_event_customer_id_idx_202024 on eld_event_202024 eld_4 (cost=0.43..2.30 rows=1 width=659) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (customer_id = ANY ('{1042463574}'::oid[]))
  • Filter: ((event_time >= '2020-05-20 03:14:15.143035'::timestamp without time zone) AND (event_time < '2020-06-26 03:14:15.143035'::timestamp without time zone))
8. 0.009 0.009 ↓ 0.0 0 1

Index Scan using eld_event_customer_id_idx_202025 on eld_event_202025 eld_5 (cost=0.43..1.93 rows=1 width=663) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (customer_id = ANY ('{1042463574}'::oid[]))
  • Filter: ((event_time >= '2020-05-20 03:14:15.143035'::timestamp without time zone) AND (event_time < '2020-06-26 03:14:15.143035'::timestamp without time zone))
9. 0.015 0.015 ↑ 2.8 4 1

Index Scan using eld_event_customer_id_idx_202026 on eld_event_202026 eld_6 (cost=0.42..3.34 rows=11 width=664) (actual time=0.011..0.015 rows=4 loops=1)

  • Index Cond: (customer_id = ANY ('{1042463574}'::oid[]))
  • Filter: ((event_time >= '2020-05-20 03:14:15.143035'::timestamp without time zone) AND (event_time < '2020-06-26 03:14:15.143035'::timestamp without time zone))
Planning time : 25.734 ms