explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ldrR

Settings
# exclusive inclusive rows x rows loops node
1. 40.587 5,642.846 ↑ 1.0 500,000 1

Limit (cost=189,456.04..376,893.66 rows=500,000 width=462) (actual time=1,671.875..5,642.846 rows=500,000 loops=1)

2. 565.594 5,602.259 ↑ 2.5 500,000 1

Hash Join (cost=189,456.04..653,175.95 rows=1,236,998 width=462) (actual time=1,671.874..5,602.259 rows=500,000 loops=1)

  • Hash Cond: (cr.provider_id = p.provider_id)
3. 999.500 5,036.360 ↑ 2.5 500,000 1

Hash Join (cost=189,454.52..624,589.02 rows=1,236,998 width=434) (actual time=1,671.838..5,036.360 rows=500,000 loops=1)

  • Hash Cond: (cr.identity_id = i.identity_id)
4. 2,375.370 2,375.721 ↑ 1.6 773,818 1

Append (cost=0.44..298,649.80 rows=1,236,998 width=257) (actual time=0.114..2,375.721 rows=773,818 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.075..0.358 rows=0 l
  • Index Cond: (received_date_time >= '2019-10-03 10:27:49'::timestamp without time zone)
  • 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
5. 0.052 0.052 ↓ 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.019..0.052 rows=0 loops=1)

6. 0.046 0.046 ↓ 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.013..0.046 rows=0 loops=1)

  • Index Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
7. 0.002 0.049 ↓ 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.016..0.049 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
8. 0.047 0.047 ↓ 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.011..0.047 rows=0 loops=1)

  • Index Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
9. 0.004 0.049 ↓ 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.015..0.049 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
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.012..0.045 rows=0 loops=1)

  • Index Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
11. 0.010 0.055 ↓ 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.016..0.055 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
12. 0.045 0.045 ↓ 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.010..0.045 rows=0 loops=1)

  • Index Cond: (provider_id = ANY ('{12055157,12055159}'::integer[]))
13. 0.005 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.012..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.040 0.040 ↓ 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.007..0.040 rows=0 loops=1)

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

Seq Scan on contact_reports_default cr_7 (cost=0.00..2.00 rows=1 width=236) (actual time=0.021..0.055 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. 934.969 1,661.139 ↓ 1.1 1,966,946 1

Hash (cost=120,420.15..120,420.15 rows=1,821,915 width=181) (actual time=1,660.622..1,661.139 rows=1,966,946 loops=1)

  • Buckets: 2097152 Batches: 2 Memory Usage: 209861kB
17. 726.170 726.170 ↓ 1.1 1,966,946 1

Seq Scan on identities i (cost=0.00..120,420.15 rows=1,821,915 width=181) (actual time=0.008..726.170 rows=1,966,946 loops=1)

18. 0.036 0.305 ↓ 1.1 26 1

Hash (cost=1.23..1.23 rows=23 width=23) (actual time=0.016..0.305 rows=26 loops=1)

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

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