explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mCwW : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #WDxp; plan #DSPq; plan #zhnO; plan #B1oG; plan #BYIm; plan #Jkox

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.103 288.275 ↑ 1.0 1,000 1

Limit (cost=1.74..5,967.65 rows=1,000 width=281) (actual time=282.321..288.275 rows=1,000 loops=1)

  • Buffers: shared hit=54915
2. 1.342 288.172 ↑ 2,226.7 1,000 1

Nested Loop (cost=1.74..13,283,995.75 rows=2,226,650 width=281) (actual time=282.320..288.172 rows=1,000 loops=1)

  • Buffers: shared hit=54915
3. 0.339 283.830 ↑ 2,226.7 1,000 1

Hash Join (cost=1.32..17,911.74 rows=2,226,650 width=815) (actual time=282.289..283.830 rows=1,000 loops=1)

  • Buffers: shared hit=50915
4. 0.209 283.473 ↑ 2,226.7 1,000 1

Nested Loop (cost=0.14..8,969.17 rows=2,226,650 width=806) (actual time=282.245..283.473 rows=1,000 loops=1)

  • Buffers: shared hit=50914
5. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on geoserver_acl g (cost=0.00..1.02 rows=1 width=185) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (username = 'coastguard'::text)
  • Buffers: shared hit=1
6. 0.088 283.254 ↑ 1.8 1,000 1

Append (cost=0.14..8,950.62 rows=1,752 width=806) (actual time=282.228..283.254 rows=1,000 loops=1)

  • Buffers: shared hit=50913
7. 0.005 0.005 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_03_09_geopoint_idx on contact_reports_p2019_03_09 cr (cost=0.14..8.17 rows=1 width=220) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
  • Buffers: shared hit=1
8. 0.004 0.004 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_03_10_geopoint_idx on contact_reports_p2019_03_10 cr_1 (cost=0.14..8.17 rows=1 width=220) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
  • Buffers: shared hit=1
9. 0.003 0.003 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_03_11_geopoint_idx on contact_reports_p2019_03_11 cr_2 (cost=0.14..8.17 rows=1 width=220) (actual time=0.003..0.003 rows=0 loops=1)

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

Index Scan using contact_reports_p2019_03_12_geopoint_idx on contact_reports_p2019_03_12 cr_3 (cost=0.14..8.17 rows=1 width=220) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
  • Buffers: shared hit=1
11. 151.629 283.149 ↓ 5.7 1,000 1

Bitmap Heap Scan on contact_reports_p2019_03_13 cr_4 (cost=10.38..1,022.38 rows=175 width=805) (actual time=282.203..283.149 rows=1,000 loops=1)

  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
  • Buffers: shared hit=50909
12. 131.520 131.520 ↓ 1,617.7 415,740 1

Bitmap Index Scan on contact_reports_p2019_03_13_geopoint_idx (cost=0.00..10.34 rows=257 width=0) (actual time=131.520..131.520 rows=415,740 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Buffers: shared hit=2799
13. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_03_14_geopoint_idx on contact_reports_p2019_03_14 cr_5 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
14. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_03_15_geopoint_idx on contact_reports_p2019_03_15 cr_6 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
15. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_03_16_geopoint_idx on contact_reports_p2019_03_16 cr_7 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
16. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_03_17_geopoint_idx on contact_reports_p2019_03_17 cr_8 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
17. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on contact_reports_p2019_03_18 cr_9 (cost=4.64..185.74 rows=43 width=798) (never executed)

  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
18. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on contact_reports_p2019_03_18_geopoint_idx (cost=0.00..4.63 rows=46 width=0) (never executed)

  • Index Cond: (geopoint && g.geometry)
19. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_03_19_geopoint_idx on contact_reports_p2019_03_19 cr_10 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
20. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_03_20_geopoint_idx on contact_reports_p2019_03_20 cr_11 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
21. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_03_21_geopoint_idx on contact_reports_p2019_03_21 cr_12 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
22. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_03_22_geopoint_idx on contact_reports_p2019_03_22 cr_13 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
23. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_03_23_geopoint_idx on contact_reports_p2019_03_23 cr_14 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
24. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_03_24_geopoint_idx on contact_reports_p2019_03_24 cr_15 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
25. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on contact_reports_p2019_03_25 cr_16 (cost=14.78..1,227.85 rows=242 width=807) (never executed)

  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
26. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on contact_reports_p2019_03_25_geopoint_idx (cost=0.00..14.72 rows=308 width=0) (never executed)

  • Index Cond: (geopoint && g.geometry)
27. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_03_26_geopoint_idx on contact_reports_p2019_03_26 cr_17 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
28. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on contact_reports_p2019_03_27 cr_18 (cost=20.93..2,324.84 rows=522 width=804) (never executed)

  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
29. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on contact_reports_p2019_03_27_geopoint_idx (cost=0.00..20.80 rows=585 width=0) (never executed)

  • Index Cond: (geopoint && g.geometry)
30. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on contact_reports_p2019_03_28 cr_19 (cost=10.01..825.14 rows=163 width=804) (never executed)

  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
31. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on contact_reports_p2019_03_28_geopoint_idx (cost=0.00..9.96 rows=207 width=0) (never executed)

  • Index Cond: (geopoint && g.geometry)
32. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on contact_reports_p2019_03_29 cr_20 (cost=26.40..3,094.39 rows=575 width=809) (never executed)

  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
33. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on contact_reports_p2019_03_29_geopoint_idx (cost=0.00..26.26 rows=779 width=0) (never executed)

  • Index Cond: (geopoint && g.geometry)
34. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_03_30_geopoint_idx on contact_reports_p2019_03_30 cr_21 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
35. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_03_31_geopoint_idx on contact_reports_p2019_03_31 cr_22 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
36. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_01_geopoint_idx on contact_reports_p2019_04_01 cr_23 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
37. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_02_geopoint_idx on contact_reports_p2019_04_02 cr_24 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
38. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_03_geopoint_idx on contact_reports_p2019_04_03 cr_25 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
39. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_04_geopoint_idx on contact_reports_p2019_04_04 cr_26 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
40. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_05_geopoint_idx on contact_reports_p2019_04_05 cr_27 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
41. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_06_geopoint_idx on contact_reports_p2019_04_06 cr_28 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
42. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_07_geopoint_idx on contact_reports_p2019_04_07 cr_29 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
43. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_08_geopoint_idx on contact_reports_p2019_04_08 cr_30 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
44. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_09_geopoint_idx on contact_reports_p2019_04_09 cr_31 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
45. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_10_geopoint_idx on contact_reports_p2019_04_10 cr_32 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
46. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_11_geopoint_idx on contact_reports_p2019_04_11 cr_33 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
47. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_12_geopoint_idx on contact_reports_p2019_04_12 cr_34 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
48. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_13_geopoint_idx on contact_reports_p2019_04_13 cr_35 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
49. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_p2019_04_14_geopoint_idx on contact_reports_p2019_04_14 cr_36 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
50. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contact_reports_default_geopoint_idx on contact_reports_default cr_37 (cost=0.14..8.17 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (provider_id = ANY (g.providers))))
51. 0.006 0.018 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=13) (actual time=0.017..0.018 rows=8 loops=1)

  • Buffers: shared hit=1
52. 0.012 0.012 ↑ 1.0 8 1

Seq Scan on providers p (cost=0.00..1.08 rows=8 width=13) (actual time=0.010..0.012 rows=8 loops=1)

  • Buffers: shared hit=1
53. 3.000 3.000 ↑ 1.0 1 1,000

Index Scan using pk_identities on identities i (cost=0.42..5.94 rows=1 width=299) (actual time=0.003..0.003 rows=1 loops=1,000)

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