explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z684

Settings
# exclusive inclusive rows x rows loops node
1. 786.126 281,565.678 ↓ 1.0 10,587,503 1

Append (cost=0.00..1,849,112.47 rows=10,578,405 width=661) (actual time=0.477..281,565.678 rows=10,587,503 loops=1)

2. 0.010 0.010 ↓ 0.0 0 1

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

  • Filter: ((customer_id = ANY ('{1265589263}'::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))
3. 2,514.981 2,514.981 ↑ 1.0 872,486 1

Seq Scan on eld_event_202022 eld_1 (cost=0.00..90,947.64 rows=872,526 width=655) (actual time=0.466..2,514.981 rows=872,486 loops=1)

  • Filter: ((customer_id = ANY ('{1265589263}'::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))
  • Rows Removed by Filter: 50,086
4. 11,475.945 11,475.945 ↑ 1.0 2,301,137 1

Seq Scan on eld_event_202023 eld_2 (cost=0.00..409,789.16 rows=2,304,270 width=660) (actual time=0.318..11,475.945 rows=2,301,137 loops=1)

  • Filter: ((customer_id = ANY ('{1265589263}'::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))
  • Rows Removed by Filter: 1,781,896
5. 5,632.082 5,632.082 ↓ 1.0 1,851,023 1

Seq Scan on eld_event_202021 eld_3 (cost=0.00..207,123.95 rows=1,841,181 width=666) (actual time=0.380..5,632.082 rows=1,851,023 loops=1)

  • Filter: ((customer_id = ANY ('{1265589263}'::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))
  • Rows Removed by Filter: 197,231
6. 124,423.121 127,433.577 ↓ 1.0 2,267,184 1

Bitmap Heap Scan on eld_event_202024 eld_4 (cost=25,398.71..501,017.35 rows=2,261,455 width=659) (actual time=3,116.501..127,433.577 rows=2,267,184 loops=1)

  • Recheck Cond: (customer_id = ANY ('{1265589263}'::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))
  • Heap Blocks: exact=384,457
7. 3,010.456 3,010.456 ↓ 1.0 2,267,184 1

Bitmap Index Scan on eld_event_customer_id_idx_202024 (cost=0.00..24,833.34 rows=2,261,455 width=0) (actual time=3,010.456..3,010.456 rows=2,267,184 loops=1)

  • Index Cond: (customer_id = ANY ('{1265589263}'::oid[]))
8. 128,174.642 131,209.410 ↑ 1.0 2,296,646 1

Bitmap Heap Scan on eld_event_202025 eld_5 (cost=25,832.94..485,510.50 rows=2,300,711 width=663) (actual time=3,136.947..131,209.410 rows=2,296,646 loops=1)

  • Recheck Cond: (customer_id = ANY ('{1265589263}'::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))
  • Heap Blocks: exact=394,961
9. 3,034.768 3,034.768 ↑ 1.0 2,296,646 1

Bitmap Index Scan on eld_event_customer_id_idx_202025 (cost=0.00..25,257.76 rows=2,300,711 width=0) (actual time=3,034.768..3,034.768 rows=2,296,646 loops=1)

  • Index Cond: (customer_id = ANY ('{1265589263}'::oid[]))
10. 2,513.547 2,513.547 ↓ 1.0 999,027 1

Seq Scan on eld_event_202026 eld_6 (cost=0.00..101,831.85 rows=998,261 width=664) (actual time=0.036..2,513.547 rows=999,027 loops=1)

  • Filter: ((customer_id = ANY ('{1265589263}'::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))
  • Rows Removed by Filter: 11,630
Planning time : 99.445 ms
Execution time : 281,995.563 ms