explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 217Pk

Settings
# exclusive inclusive rows x rows loops node
1. 34.583 6,000.480 ↑ 1.0 500,000 1

Limit (cost=196,275.93..386,951.29 rows=500,000 width=462) (actual time=2,062.671..6,000.480 rows=500,000 loops=1)

2. 587.725 5,965.897 ↑ 2.4 500,000 1

Hash Join (cost=196,275.93..655,906.13 rows=1,205,269 width=462) (actual time=2,062.670..5,965.897 rows=500,000 loops=1)

3. 920.508 5,377.887 ↑ 2.4 500,000 1

Hash Join (cost=196,274.41..628,052.42 rows=1,205,269 width=434) (actual time=2,062.640..5,377.887 rows=500,000 loops=1)

  • Hash Cond: (cr.identity_id = i.identity_id)
4. 2,409.546 2,409.846 ↑ 1.6 743,605 1

Append (cost=0.44..293,992.61 rows=1,205,269 width=257) (actual time=0.108..2,409.846 rows=743,605 loops=1)

  • -> Index Scan using contact_reports_p2019_10_02_received_date_time_idx on contact_reports_p2019_10_02 cr (cost=0.44..3664.80 rows=17343 width=255) (actual time=0.062..0.303 rows=0 l
  • Index Cond: (received_date_time >= '2019-10-03 10:27:49'::timestamp without time zone)
  • Filter: ((geopoint && '0103000020E61000000100000006000000FDFFFFFF7FDF38C034EA5FC4E42D454000000000B03966C0F079E7FAED74444000000000B03966C0F079E7FAED7444400000000090D463C00E69492E
  • Rows Removed by Filter: 5
  • -> Index Scan using contact_reports_p2019_10_03_received_date_time_idx on contact_reports_p2019_10_03 cr_1 (cost=0.43..284251.18 rows=1187920 width=257) (actual time=0.046..2362.832
  • Index Cond: (received_date_time >= '2019-10-03 10:27:49'::timestamp without time zone)
  • Filter: ((geopoint && '0103000020E61000000100000006000000FDFFFFFF7FDF38C034EA5FC4E42D454000000000B03966C0F079E7FAED74444000000000B03966C0F079E7FAED7444400000000090D463C00E69492E
  • Rows Removed by Filter: 3194641
5. 0.011 0.063 ↓ 0.0 0 1

Bitmap Heap Scan on contact_reports_p2019_10_04 cr_2 (cost=4.31..9.66 rows=1 width=236) (actual time=0.012..0.063 rows=0 loops=1)

  • Recheck Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
  • Filter: ((received_date_time >= '2019-10-03 10:27:49'::timestamp without time zone) AND (geopoint && '0103000020E61000000100000006000000FDFFFFFF7FDF38C034EA5FC4E42D454000000000B
6. 0.052 0.052 ↓ 0.0 0 1

Bitmap Index Scan on contact_reports_p2019_10_04_provider_id_idx (cost=0.00..4.30 rows=2 width=0) (actual time=0.011..0.052 rows=0 loops=1)

  • Index Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
7. 0.001 0.045 ↓ 0.0 0 1

Bitmap Heap Scan on contact_reports_p2019_10_05 cr_3 (cost=4.31..9.66 rows=1 width=236) (actual time=0.005..0.045 rows=0 loops=1)

  • Recheck Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
  • Filter: ((received_date_time >= '2019-10-03 10:27:49'::timestamp without time zone) AND (geopoint && '0103000020E61000000100000006000000FDFFFFFF7FDF38C034EA5FC4E42D454000000000B03966C0F079E7FAED74444000000000B03966C0F079E7FAED7444400000000090D463C00E69492ED93255405A000000006C0BC064465B2EE2345540FDFFFFFF7FDF38C034EA5FC4E42D4540'::geometry))
8. 0.044 0.044 ↓ 0.0 0 1

Bitmap Index Scan on contact_reports_p2019_10_05_provider_id_idx (cost=0.00..4.30 rows=2 width=0) (actual time=0.004..0.044 rows=0 loops=1)

  • Index Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
9. 0.000 0.045 ↓ 0.0 0 1

Bitmap Heap Scan on contact_reports_p2019_10_06 cr_4 (cost=4.31..9.66 rows=1 width=236) (actual time=0.005..0.045 rows=0 loops=1)

  • Recheck Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
  • Filter: ((received_date_time >= '2019-10-03 10:27:49'::timestamp without time zone) AND (geopoint && '0103000020E61000000100000006000000FDFFFFFF7FDF38C034EA5FC4E42D454000000000B03966C0F079E7FAED74444000000000B03966C0F079E7FAED7444400000000090D463C00E69492ED93255405A000000006C0BC064465B2EE2345540FDFFFFFF7FDF38C034EA5FC4E42D4540'::geometry))
10. 0.045 0.045 ↓ 0.0 0 1

Bitmap Index Scan on contact_reports_p2019_10_06_provider_id_idx (cost=0.00..4.30 rows=2 width=0) (actual time=0.004..0.045 rows=0 loops=1)

  • Index Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
11. 0.000 0.046 ↓ 0.0 0 1

Bitmap Heap Scan on contact_reports_p2019_10_07 cr_5 (cost=4.31..9.66 rows=1 width=236) (actual time=0.006..0.046 rows=0 loops=1)

  • Recheck Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
  • Filter: ((received_date_time >= '2019-10-03 10:27:49'::timestamp without time zone) AND (geopoint && '0103000020E61000000100000006000000FDFFFFFF7FDF38C034EA5FC4E42D454000000000B03966C0F079E7FAED74444000000000B03966C0F079E7FAED7444400000000090D463C00E69492ED93255405A000000006C0BC064465B2EE2345540FDFFFFFF7FDF38C034EA5FC4E42D4540'::geometry))
12. 0.047 0.047 ↓ 0.0 0 1

Bitmap Index Scan on contact_reports_p2019_10_07_provider_id_idx (cost=0.00..4.30 rows=2 width=0) (actual time=0.005..0.047 rows=0 loops=1)

  • Index Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
13. 0.001 0.045 ↓ 0.0 0 1

Bitmap Heap Scan on contact_reports_p2019_10_08 cr_6 (cost=4.31..9.66 rows=1 width=236) (actual time=0.004..0.045 rows=0 loops=1)

  • Recheck Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
  • Filter: ((received_date_time >= '2019-10-03 10:27:49'::timestamp without time zone) AND (geopoint && '0103000020E61000000100000006000000FDFFFFFF7FDF38C034EA5FC4E42D454000000000B03966C0F079E7FAED74444000000000B03966C0F079E7FAED7444400000000090D463C00E69492ED93255405A000000006C0BC064465B2EE2345540FDFFFFFF7FDF38C034EA5FC4E42D4540'::geometry))
14. 0.044 0.044 ↓ 0.0 0 1

Bitmap Index Scan on contact_reports_p2019_10_08_provider_id_idx (cost=0.00..4.30 rows=2 width=0) (actual time=0.004..0.044 rows=0 loops=1)

  • Index Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
15. 0.056 0.056 ↓ 0.0 0 1

Seq Scan on contact_reports_default cr_7 (cost=0.00..2.00 rows=1 width=236) (actual time=0.011..0.056 rows=0 loops=1)

  • Filter: ((received_date_time >= '2019-10-03 10:27:49'::timestamp without time zone) AND (geopoint && '0103000020E61000000100000006000000FDFFFFFF7FDF38C034EA5FC4E42D454000000000B03966C0F079E7FAED74444000000000B03966C0F079E7FAED7444400000000090D463C00E69492ED93255405A000000006C0BC064465B2EE2345540FDFFFFFF7FDF38C034EA5FC4E42D4540'::geometry) AND (provider_id = ANY ('{12055157,12055159}'::integer[])))
16. 1,072.814 2,047.533 ↓ 1.0 1,966,907 1

Hash (cost=121,844.10..121,844.10 rows=1,964,310 width=181) (actual time=2,047.158..2,047.533 rows=1,966,907 loops=1)

  • Buckets: 2097152 Batches: 2 Memory Usage: 209859kB
17. 974.719 974.719 ↓ 1.0 1,966,907 1

Seq Scan on identities i (cost=0.00..121,844.10 rows=1,964,310 width=181) (actual time=0.008..974.719 rows=1,966,907 loops=1)

18. 0.039 0.285 ↓ 1.1 26 1

Hash (cost=1.23..1.23 rows=23 width=23) (actual time=0.015..0.285 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
19. 0.246 0.246 ↓ 1.1 26 1

Seq Scan on providers p (cost=0.00..1.23 rows=23 width=23) (actual time=0.005..0.246 rows=26 loops=1)