explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B1oG : Optimization for: Optimization for: Optimization for: plan #WDxp; plan #DSPq; plan #zhnO

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.124 381.580 ↑ 1.0 1,000 1

Limit (cost=1.74..6,885.70 rows=1,000 width=281) (actual time=367.523..381.580 rows=1,000 loops=1)

  • Buffers: shared hit=93415
2. 1.353 381.456 ↑ 10.6 1,000 1

Nested Loop (cost=1.74..73,095.60 rows=10,618 width=281) (actual time=367.521..381.456 rows=1,000 loops=1)

  • Buffers: shared hit=93415
3. 0.359 377.103 ↑ 10.6 1,000 1

Hash Join (cost=1.32..9,834.77 rows=10,618 width=816) (actual time=367.503..377.103 rows=1,000 loops=1)

  • Buffers: shared hit=89414
4. 0.219 376.730 ↑ 10.6 1,000 1

Nested Loop (cost=0.14..9,790.95 rows=10,618 width=807) (actual time=367.477..376.730 rows=1,000 loops=1)

  • Buffers: shared hit=89413
5. 0.016 0.016 ↑ 1.0 1 1

Seq Scan on geoserver_acl g (cost=0.00..1.01 rows=1 width=57) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (username = 'cmaoi'::text)
  • Buffers: shared hit=1
6. 0.088 376.495 ↑ 1.1 1,000 1

Append (cost=0.14..9,778.95 rows=1,099 width=807) (actual time=367.453..376.495 rows=1,000 loops=1)

  • Buffers: shared hit=89412
7. 0.000 0.006 ↓ 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.55 rows=1 width=220) (actual time=0.006..0.006 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 (SubPlan 1)))
  • Buffers: shared hit=1
8.          

SubPlan (forIndex Scan)

9. 85.885 85.885 ↑ 100.0 1 85,885

ProjectSet (cost=0.00..0.52 rows=100 width=4) (actual time=0.000..0.001 rows=1 loops=85,885)

10. 0.000 0.000 ↑ 1.0 1 85,885

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=85,885)

11. 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.55 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 (SubPlan 1)))
  • Buffers: shared hit=1
12. 0.004 0.004 ↓ 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.55 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 (SubPlan 1)))
  • Buffers: shared hit=1
13. 0.006 0.006 ↓ 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.55 rows=1 width=220) (actual time=0.005..0.006 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 (SubPlan 1)))
  • Buffers: shared hit=1
14. 264.044 376.387 ↓ 10.1 1,000 1

Bitmap Heap Scan on contact_reports_p2019_03_13 cr_4 (cost=10.36..1,118.42 rows=99 width=806) (actual time=367.427..376.387 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 (SubPlan 1)))
  • Buffers: shared hit=89408
15. 112.343 112.343 ↓ 1,681.8 432,227 1

Bitmap Index Scan on contact_reports_p2019_03_13_geopoint_idx (cost=0.00..10.34 rows=257 width=0) (actual time=112.343..112.343 rows=432,227 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Buffers: shared hit=2907
16. 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.55 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 (SubPlan 1)))
17. 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.55 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 (SubPlan 1)))
18. 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.55 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 (SubPlan 1)))
19. 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.55 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 (SubPlan 1)))
20. 0.000 0.000 ↓ 0.0 0 0

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

  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (SubPlan 1)))
21. 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)
22. 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.55 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 (SubPlan 1)))
23. 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.55 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 (SubPlan 1)))
24. 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.55 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 (SubPlan 1)))
25. 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.55 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 (SubPlan 1)))
26. 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.55 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 (SubPlan 1)))
27. 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.55 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 (SubPlan 1)))
28. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on contact_reports_p2019_03_25 cr_16 (cost=14.76..1,342.95 rows=155 width=807) (never executed)

  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (SubPlan 1)))
29. 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)
30. 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.55 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 (SubPlan 1)))
31. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on contact_reports_p2019_03_27 cr_18 (cost=20.88..2,543.43 rows=294 width=806) (never executed)

  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (SubPlan 1)))
32. 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)
33. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on contact_reports_p2019_03_28 cr_19 (cost=9.99..902.49 rows=104 width=803) (never executed)

  • Filter: ((received_date_time > '2019-03-13 16:00:00'::timestamp without time zone) AND ((g.providers IS NULL) OR (SubPlan 1)))
34. 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)
35. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on contact_reports_p2019_03_29 cr_20 (cost=26.36..3,389.77 rows=392 width=810) (never executed)

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

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

  • Index Cond: (geopoint && g.geometry)
37. 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.55 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 (SubPlan 1)))
38. 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.55 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 (SubPlan 1)))
39. 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.55 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 (SubPlan 1)))
40. 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.55 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 (SubPlan 1)))
41. 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.55 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 (SubPlan 1)))
42. 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.55 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 (SubPlan 1)))
43. 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.55 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 (SubPlan 1)))
44. 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.55 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 (SubPlan 1)))
45. 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.55 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 (SubPlan 1)))
46. 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.55 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 (SubPlan 1)))
47. 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.55 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 (SubPlan 1)))
48. 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.55 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 (SubPlan 1)))
49. 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.55 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 (SubPlan 1)))
50. 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.55 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 (SubPlan 1)))
51. 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.55 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 (SubPlan 1)))
52. 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.55 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 (SubPlan 1)))
53. 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.55 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 (SubPlan 1)))
54. 0.005 0.014 ↑ 1.0 8 1

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

  • Buffers: shared hit=1
55. 0.009 0.009 ↑ 1.0 8 1

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

  • Buffers: shared hit=1
56. 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=297) (actual time=0.003..0.003 rows=1 loops=1,000)

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