explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SJZU

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.168 846.810 ↑ 1.0 10,000 1

Limit (cost=1.74..59,664.62 rows=10,000 width=281) (actual time=657.251..846.810 rows=10,000 loops=1)

  • Buffers: shared hit=177111
2. 17.602 845.642 ↑ 199.4 10,000 1

Nested Loop (cost=1.74..11,897,620.28 rows=1,994,141 width=281) (actual time=657.250..845.642 rows=10,000 loops=1)

  • Buffers: shared hit=177111
3. 4.134 788.040 ↑ 199.4 10,000 1

Hash Join (cost=1.32..16,679.89 rows=1,994,141 width=816) (actual time=657.219..788.040 rows=10,000 loops=1)

  • Buffers: shared hit=137111
4. 2.425 783.888 ↑ 199.4 10,000 1

Nested Loop (cost=0.14..8,670.99 rows=1,994,141 width=807) (actual time=657.187..783.888 rows=10,000 loops=1)

  • Buffers: shared hit=137110
5. 0.012 0.012 ↑ 1.0 1 1

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

  • Filter: (username = 'cmaoi'::text)
  • Buffers: shared hit=1
6. 1.088 781.451 ↓ 10.1 10,000 1

Append (cost=0.14..8,660.01 rows=995 width=807) (actual time=657.168..781.451 rows=10,000 loops=1)

  • Buffers: shared hit=137109
7. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
8.          

SubPlan (forIndex Scan)

9. 351.755 351.755 ↑ 100.0 1 351,755

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

10. 0.000 0.000 ↑ 1.0 1 351,755

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

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-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
12. 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.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-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
13. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
14. 0.005 0.005 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_03_14_geopoint_idx on contact_reports_p2019_03_14 cr_4 (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-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
15. 0.004 0.004 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_03_15_geopoint_idx on contact_reports_p2019_03_15 cr_5 (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-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
16. 0.003 0.003 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_03_16_geopoint_idx on contact_reports_p2019_03_16 cr_6 (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-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
17. 0.007 0.007 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_03_17_geopoint_idx on contact_reports_p2019_03_17 cr_7 (cost=0.14..8.55 rows=1 width=220) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
18. 240.443 269.602 ↓ 0.0 0 1

Bitmap Heap Scan on contact_reports_p2019_03_18 cr_8 (cost=4.64..202.93 rows=23 width=797) (actual time=269.602..269.602 rows=0 loops=1)

  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=43993
19. 29.159 29.159 ↓ 3,203.5 147,362 1

Bitmap Index Scan on contact_reports_p2019_03_18_geopoint_idx (cost=0.00..4.63 rows=46 width=0) (actual time=29.159..29.159 rows=147,362 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Buffers: shared hit=1008
20. 0.011 0.011 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_03_19_geopoint_idx on contact_reports_p2019_03_19 cr_9 (cost=0.14..8.55 rows=1 width=220) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
21. 0.004 0.004 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_03_20_geopoint_idx on contact_reports_p2019_03_20 cr_10 (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-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
22. 0.004 0.004 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_03_21_geopoint_idx on contact_reports_p2019_03_21 cr_11 (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-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
23. 0.004 0.004 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_03_22_geopoint_idx on contact_reports_p2019_03_22 cr_12 (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-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
24. 0.004 0.004 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_03_23_geopoint_idx on contact_reports_p2019_03_23 cr_13 (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-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
25. 0.004 0.004 ↓ 0.0 0 1

Index Scan using contact_reports_p2019_03_24_geopoint_idx on contact_reports_p2019_03_24 cr_14 (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-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=1
26. 384.474 510.695 ↓ 64.9 10,000 1

Bitmap Heap Scan on contact_reports_p2019_03_25 cr_15 (cost=14.76..1,342.95 rows=154 width=807) (actual time=387.470..510.695 rows=10,000 loops=1)

  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
  • Buffers: shared hit=93102
27. 126.221 126.221 ↓ 1,587.1 488,822 1

Bitmap Index Scan on contact_reports_p2019_03_25_geopoint_idx (cost=0.00..14.72 rows=308 width=0) (actual time=126.221..126.221 rows=488,822 loops=1)

  • Index Cond: (geopoint && g.geometry)
  • Buffers: shared hit=3411
28. 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_16 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
29. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on contact_reports_p2019_03_27 cr_17 (cost=20.88..2,543.43 rows=293 width=805) (never executed)

  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
30. 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)
31. 0.000 0.000 ↓ 0.0 0 0

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

  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
32. 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)
33. 0.000 0.000 ↓ 0.0 0 0

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

  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
34. 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)
35. 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_20 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
36. 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_21 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
37. 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_22 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
38. 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_23 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
39. 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_24 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
40. 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_25 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
41. 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_26 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
42. 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_27 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
43. 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_28 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
44. 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_29 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
45. 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_30 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
46. 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_31 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
47. 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_32 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
48. 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_33 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
49. 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_34 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
50. 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_35 (cost=0.14..8.55 rows=1 width=220) (never executed)

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
51. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (geopoint && g.geometry)
  • Filter: ((received_date_time > '2019-03-18 08:00:00'::timestamp without time zone) AND (SubPlan 1))
52. 0.005 0.018 ↑ 1.0 8 1

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

  • Buffers: shared hit=1
53. 0.013 0.013 ↑ 1.0 8 1

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

  • Buffers: shared hit=1
54. 40.000 40.000 ↑ 1.0 1 10,000

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

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