explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.130 239.926 ↑ 1.0 1,000 1

Limit (cost=1.74..5,966.70 rows=1,000 width=281) (actual time=232.738..239.926 rows=1,000 loops=1)

  • Buffers: shared hit=54915
2. 2.258 239.796 ↑ 3,184.3 1,000 1

Nested Loop (cost=1.74..18,994,182.56 rows=3,184,295 width=281) (actual time=232.737..239.796 rows=1,000 loops=1)

  • Buffers: shared hit=54915
3. 0.375 234.538 ↑ 3,184.3 1,000 1

Hash Join (cost=1.32..22,574.81 rows=3,184,295 width=815) (actual time=232.712..234.538 rows=1,000 loops=1)

  • Buffers: shared hit=50915
4. 0.226 234.148 ↑ 3,184.3 1,000 1

Nested Loop (cost=0.14..9,786.69 rows=3,184,295 width=806) (actual time=232.684..234.148 rows=1,000 loops=1)

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

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

  • Filter: (username = 'coastguard'::text)
  • Buffers: shared hit=1
6. 0.095 233.913 ↑ 1.1 1,000 1

Append (cost=0.14..9,774.68 rows=1,099 width=806) (actual time=232.669..233.913 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.55 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 (SubPlan 1)))
  • Buffers: shared hit=1
8.          

SubPlan (forIndex Scan)

9. 0.000 0.000 ↓ 0.0 0 0

ProjectSet (cost=0.00..0.52 rows=100 width=4) (never executed)

10. 0.000 0.000 ↓ 0.0 0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

11. 0.003 0.003 ↓ 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.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 (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.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.55 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 (SubPlan 1)))
  • Buffers: shared hit=1
14. 120.348 233.801 ↓ 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=805) (actual time=232.647..233.801 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=50909
15. 113.453 113.453 ↓ 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=113.453..113.453 rows=415,740 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Buffers: shared hit=2799
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=804) (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=804) (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,385.49 rows=392 width=809) (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.26 rows=779 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.004 0.015 ↑ 1.0 8 1

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

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

Seq Scan on providers p (cost=0.00..1.08 rows=8 width=13) (actual time=0.009..0.011 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=299) (actual time=0.003..0.003 rows=1 loops=1,000)

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