explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bReI

Settings
# exclusive inclusive rows x rows loops node
1. 42.159 2,748.079 ↓ 9.8 216,651 1

Limit (cost=2.38..14,580.82 rows=22,038 width=295) (actual time=594.513..2,748.079 rows=216,651 loops=1)

  • Buffers: shared hit=1028789
2. 511.548 2,705.920 ↓ 9.8 216,651 1

Nested Loop (cost=2.38..14,580.82 rows=22,038 width=295) (actual time=594.510..2,705.920 rows=216,651 loops=1)

  • Buffers: shared hit=1028789
3. 136.605 1,327.768 ↓ 9.8 216,651 1

Hash Join (cost=1.95..1,981.02 rows=22,038 width=279) (actual time=594.452..1,327.768 rows=216,651 loops=1)

  • Buffers: shared hit=162185
4. 64.514 1,191.130 ↓ 9.8 216,651 1

Nested Loop (cost=0.43..1,910.99 rows=22,038 width=260) (actual time=594.386..1,191.130 rows=216,651 loops=1)

  • Buffers: shared hit=162184
5. 0.021 0.021 ↑ 1.0 1 1

Seq Scan on geoserver_acl g (cost=0.00..1.04 rows=1 width=175) (actual time=0.017..0.021 rows=1 loops=1)

  • Filter: (username = 'cmaoi'::text)
  • Buffers: shared hit=1
6. 34.826 1,126.595 ↓ 1,473.8 216,651 1

Append (cost=0.43..1,908.49 rows=147 width=260) (actual time=594.361..1,126.595 rows=216,651 loops=1)

  • Buffers: shared hit=162183
7. 0.034 0.034 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_06_11_received_date_time_idx on contact_reports_p2019_06_11 cr (cost=0.43..8.47 rows=1 width=258) (actual time=0.033..0.034 rows=0 loops=1)

  • Index Cond: ((received_date_time >= '2019-06-12 08:00:00'::timestamp without time zone) AND (received_date_time <= '2019-06-13 08:00:00'::timestamp without time zone))
  • Filter: ((geopoint && g.geometry) AND (provider_id = ANY (g.providers)))
  • Buffers: shared hit=3
8. 903.694 1,091.514 ↓ 1,547.5 216,651 1

Bitmap Heap Scan on contact_reports_p2019_06_12 cr_1 (cost=19.99..1,850.23 rows=140 width=260) (actual time=594.320..1,091.514 rows=216,651 loops=1)

  • Filter: ((received_date_time >= '2019-06-12 08:00:00'::timestamp without time zone) AND (received_date_time <= '2019-06-13 08:00:00'::timestamp without time zone) AND (provider_id = ANY (g.providers)))
  • Buffers: shared hit=162174
9. 187.820 187.820 ↓ 1,843.9 870,340 1

Bitmap Index Scan on contact_reports_p2019_06_12_geopoint_idx (cost=0.00..19.95 rows=472 width=0) (actual time=187.820..187.820 rows=870,340 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Buffers: shared hit=5594
10. 0.054 0.054 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_06_13_geopoint_idx on contact_reports_p2019_06_13 cr_2 (cost=0.14..8.18 rows=1 width=236) (actual time=0.054..0.054 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time >= '2019-06-12 08:00:00'::timestamp without time zone) AND (received_date_time <= '2019-06-13 08:00:00'::timestamp without time zone) AND (provider_id = ANY (g.providers)))
  • Buffers: shared hit=1
11. 0.031 0.031 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_06_14_geopoint_idx on contact_reports_p2019_06_14 cr_3 (cost=0.14..8.18 rows=1 width=236) (actual time=0.031..0.031 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time >= '2019-06-12 08:00:00'::timestamp without time zone) AND (received_date_time <= '2019-06-13 08:00:00'::timestamp without time zone) AND (provider_id = ANY (g.providers)))
  • Buffers: shared hit=1
12. 0.034 0.034 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_06_15_geopoint_idx on contact_reports_p2019_06_15 cr_4 (cost=0.14..8.18 rows=1 width=236) (actual time=0.034..0.034 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time >= '2019-06-12 08:00:00'::timestamp without time zone) AND (received_date_time <= '2019-06-13 08:00:00'::timestamp without time zone) AND (provider_id = ANY (g.providers)))
  • Buffers: shared hit=1
13. 0.039 0.039 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_06_16_geopoint_idx on contact_reports_p2019_06_16 cr_5 (cost=0.14..8.18 rows=1 width=236) (actual time=0.039..0.039 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time >= '2019-06-12 08:00:00'::timestamp without time zone) AND (received_date_time <= '2019-06-13 08:00:00'::timestamp without time zone) AND (provider_id = ANY (g.providers)))
  • Buffers: shared hit=1
14. 0.033 0.033 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_06_17_geopoint_idx on contact_reports_p2019_06_17 cr_6 (cost=0.14..8.18 rows=1 width=236) (actual time=0.033..0.033 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time >= '2019-06-12 08:00:00'::timestamp without time zone) AND (received_date_time <= '2019-06-13 08:00:00'::timestamp without time zone) AND (provider_id = ANY (g.providers)))
  • Buffers: shared hit=1
15. 0.030 0.030 ↓ 0.0 0 1

Index Scan using contact_reports_default_geopoint_idx on contact_reports_default cr_7 (cost=0.14..8.18 rows=1 width=236) (actual time=0.030..0.030 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time >= '2019-06-12 08:00:00'::timestamp without time zone) AND (received_date_time <= '2019-06-13 08:00:00'::timestamp without time zone) AND (provider_id = ANY (g.providers)))
  • Buffers: shared hit=1
16. 0.013 0.033 ↓ 1.1 26 1

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

  • Buffers: shared hit=1
17. 0.020 0.020 ↓ 1.1 26 1

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

  • Buffers: shared hit=1
18. 866.604 866.604 ↑ 1.0 1 216,651

Index Scan using pk_identities on identities i (cost=0.43..0.55 rows=1 width=204) (actual time=0.004..0.004 rows=1 loops=216,651)

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