explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8otf

Settings
# exclusive inclusive rows x rows loops node
1. 6.831 2,809.177 ↑ 1.0 100,000 1

Limit (cost=196,778.02..237,028.24 rows=100,000 width=462) (actual time=1,689.818..2,809.177 rows=100,000 loops=1)

2. 117.073 2,802.346 ↑ 7.7 100,000 1

Hash Join (cost=196,778.02..508,265.18 rows=773,877 width=462) (actual time=1,689.817..2,802.346 rows=100,000 loops=1)

  • Hash Cond: (cr.provider_id = p.provider_id)
3. 127.516 2,685.192 ↑ 7.7 100,000 1

Hash Join (cost=196,776.51..490,380.37 rows=773,877 width=433) (actual time=1,689.774..2,685.192 rows=100,000 loops=1)

  • Hash Cond: (cr.identity_id = i.identity_id)
4. 11.074 879.377 ↑ 4.3 179,962 1

Append (cost=0.44..187,016.87 rows=773,877 width=257) (actual time=0.525..879.377 rows=179,962 loops=1)

5. 0.065 0.065 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_10_02_received_date_time_idx on contact_reports_p2019_10_02 cr (cost=0.44..857.85 rows=4,031 width=255) (actual time=0.016..0.065 rows=0 loops=1)

  • Index Cond: (received_date_time >= '2019-10-03 12:27:49'::timestamp without time zone)
  • Filter: ((geopoint && '0103000020E61000000100000006000000FDFFFFFF7FDF38C034EA5FC4E42D454000000000B03966C0F079E7FAED74444000000000B03966C0F079E7FAED7444400000000090D463C00E69492ED93255405A000000006C0BC064465B2EE2345540FDFFFFFF7FDF38C034EA5FC4E42D4540'::geometry) AND (provider_id = ANY ('{12055157,12055159}'::integer[])))
  • Rows Removed by Filter: 1
6. 868.238 868.238 ↑ 4.3 179,962 1

Index Scan using contact_reports_p2019_10_03_received_date_time_idx on contact_reports_p2019_10_03 cr_1 (cost=0.43..182,239.35 rows=769,840 width=257) (actual time=0.509..868.238 rows=179,962 loops=1)

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

Bitmap Heap Scan on contact_reports_p2019_10_04 cr_2 (cost=4.31..9.66 rows=1 width=236) (never executed)

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

Bitmap Index Scan on contact_reports_p2019_10_04_provider_id_idx (cost=0.00..4.30 rows=2 width=0) (never executed)

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

Bitmap Heap Scan on contact_reports_p2019_10_05 cr_3 (cost=4.31..9.66 rows=1 width=236) (never executed)

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

Bitmap Index Scan on contact_reports_p2019_10_05_provider_id_idx (cost=0.00..4.30 rows=2 width=0) (never executed)

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

Bitmap Heap Scan on contact_reports_p2019_10_06 cr_4 (cost=4.31..9.66 rows=1 width=236) (never executed)

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

Bitmap Index Scan on contact_reports_p2019_10_06_provider_id_idx (cost=0.00..4.30 rows=2 width=0) (never executed)

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

Bitmap Heap Scan on contact_reports_p2019_10_07 cr_5 (cost=4.31..9.66 rows=1 width=236) (never executed)

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

Bitmap Index Scan on contact_reports_p2019_10_07_provider_id_idx (cost=0.00..4.30 rows=2 width=0) (never executed)

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

Bitmap Heap Scan on contact_reports_p2019_10_08 cr_6 (cost=4.31..9.66 rows=1 width=236) (never executed)

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

Bitmap Index Scan on contact_reports_p2019_10_08_provider_id_idx (cost=0.00..4.30 rows=2 width=0) (never executed)

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

Seq Scan on contact_reports_default cr_7 (cost=0.00..2.00 rows=1 width=236) (never executed)

  • Filter: ((received_date_time >= '2019-10-03 12:27:49'::timestamp without time zone) AND (geopoint && '0103000020E61000000100000006000000FDFFFFFF7FDF38C034EA5FC4E42D454000000000B03966C0F079E7FAED74444000000000B03966C0F079E7FAED7444400000000090D463C00E69492ED93255405A000000006C0BC064465B2EE2345540FDFFFFFF7FDF38C034EA5FC4E42D4540'::geometry) AND (provider_id = ANY ('{12055157,12055159}'::integer[])))
18. 941.961 1,678.299 ↑ 1.0 1,967,073 1

Hash (cost=121,949.03..121,949.03 rows=1,974,803 width=180) (actual time=1,678.204..1,678.299 rows=1,967,073 loops=1)

  • Buckets: 2097152 Batches: 2 Memory Usage: 209870kB
19. 736.338 736.338 ↑ 1.0 1,967,073 1

Seq Scan on identities i (cost=0.00..121,949.03 rows=1,974,803 width=180) (actual time=0.011..736.338 rows=1,967,073 loops=1)

20. 0.017 0.081 ↓ 1.1 26 1

Hash (cost=1.23..1.23 rows=23 width=23) (actual time=0.021..0.081 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
21. 0.064 0.064 ↓ 1.1 26 1

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