explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TcbA

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 307.587 2,545.879 ↓ 124.5 80,294 1

Nested Loop (cost=31.69..11,002.02 rows=645 width=277) (actual time=989.072..2,545.879 rows=80,294 loops=1)

  • Buffers: shared hit=577122
2. 136.865 1,836.822 ↓ 124.5 80,294 1

Nested Loop (cost=31.26..10,683.03 rows=645 width=182) (actual time=988.992..1,836.822 rows=80,294 loops=1)

  • Buffers: shared hit=254936
3. 24.126 1,619.663 ↓ 124.5 80,294 1

Nested Loop (cost=31.26..10,602.62 rows=645 width=169) (actual time=988.935..1,619.663 rows=80,294 loops=1)

  • Buffers: shared hit=254935
4. 0.023 0.023 ↑ 3.0 1 1

Seq Scan on geoserver_acl g (cost=0.00..16.88 rows=3 width=64) (actual time=0.019..0.023 rows=1 loops=1)

  • Filter: (username = 'cmaoi'::text)
  • Buffers: shared hit=1
5. 16.307 1,595.514 ↓ 250.1 80,294 1

Append (cost=31.26..3,525.37 rows=321 width=169) (actual time=988.902..1,595.514 rows=80,294 loops=1)

  • Buffers: shared hit=254934
6. 1,175.903 1,578.952 ↓ 254.9 80,294 1

Bitmap Heap Scan on contact_reports_p2019_04_10 cr (cost=31.26..3,490.73 rows=315 width=169) (actual time=988.895..1,578.952 rows=80,294 loops=1)

  • Filter: ((report_date_time > '2019-04-10 08:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
  • Buffers: shared hit=254928
7. 403.049 403.049 ↓ 1,465.8 1,322,140 1

Bitmap Index Scan on contact_reports_p2019_04_10_geopoint_idx (cost=0.00..31.18 rows=902 width=0) (actual time=403.049..403.049 rows=1,322,140 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Buffers: shared hit=8179
8. 0.060 0.060 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_04_11_geopoint_idx on contact_reports_p2019_04_11 cr_1 (cost=0.14..5.51 rows=1 width=220) (actual time=0.060..0.060 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((report_date_time > '2019-04-10 08:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
  • Buffers: shared hit=1
9. 0.046 0.046 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_04_12_geopoint_idx on contact_reports_p2019_04_12 cr_2 (cost=0.14..5.51 rows=1 width=220) (actual time=0.046..0.046 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((report_date_time > '2019-04-10 08:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
  • Buffers: shared hit=1
10. 0.032 0.032 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_04_13_geopoint_idx on contact_reports_p2019_04_13 cr_3 (cost=0.14..5.51 rows=1 width=220) (actual time=0.032..0.032 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((report_date_time > '2019-04-10 08:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
  • Buffers: shared hit=1
11. 0.035 0.035 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_04_14_geopoint_idx on contact_reports_p2019_04_14 cr_4 (cost=0.14..5.51 rows=1 width=220) (actual time=0.035..0.035 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((report_date_time > '2019-04-10 08:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
  • Buffers: shared hit=1
12. 0.042 0.042 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_04_15_geopoint_idx on contact_reports_p2019_04_15 cr_5 (cost=0.14..5.51 rows=1 width=220) (actual time=0.042..0.042 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((report_date_time > '2019-04-10 08:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
  • Buffers: shared hit=1
13. 0.040 0.040 ↓ 0.0 0 1

Index Scan using contact_reports_default_geopoint_idx on contact_reports_default cr_6 (cost=0.14..5.51 rows=1 width=220) (actual time=0.040..0.040 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((report_date_time > '2019-04-10 08:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
  • Buffers: shared hit=1
14. 80.270 80.294 ↓ 1.1 10 80,294

Materialize (cost=0.00..1.14 rows=9 width=17) (actual time=0.000..0.001 rows=10 loops=80,294)

  • Buffers: shared hit=1
15. 0.024 0.024 ↓ 1.1 10 1

Seq Scan on providers p (cost=0.00..1.09 rows=9 width=17) (actual time=0.022..0.024 rows=10 loops=1)

  • Buffers: shared hit=1
16. 401.470 401.470 ↑ 1.0 1 80,294

Index Scan using pk_identities on identities i (cost=0.42..0.47 rows=1 width=245) (actual time=0.005..0.005 rows=1 loops=80,294)

  • Index Cond: (identity_id = cr.identity_id)
  • Buffers: shared hit=322186