explain.depesz.com

PostgreSQL's explain analyze made readable

Result: at3O

Settings
# exclusive inclusive rows x rows loops node
1. 22.733 3,180.726 ↓ 728.6 196,713 1

Limit (cost=5,635.63..5,636.31 rows=270 width=295) (actual time=3,091.613..3,180.726 rows=196,713 loops=1)

2. 571.239 3,157.993 ↓ 728.6 196,713 1

Sort (cost=5,635.63..5,636.31 rows=270 width=295) (actual time=3,091.611..3,157.993 rows=196,713 loops=1)

  • Sort Method: external merge Disk: 56016kB
3. 490.717 2,586.754 ↓ 728.6 196,713 1

Hash Join (cost=2.38..5,624.73 rows=270 width=295) (actual time=551.690..2,586.754 rows=196,713 loops=1)

4. 202.035 2,095.997 ↓ 728.6 196,713 1

Nested Loop (cost=0.86..5,616.97 rows=270 width=458) (actual time=551.568..2,095.997 rows=196,713 loops=1)

5. 54.658 1,107.110 ↓ 728.6 196,713 1

Nested Loop (cost=0.43..5,465.02 rows=270 width=260) (actual time=551.489..1,107.110 rows=196,713 loops=1)

6. 0.013 0.013 ↑ 3.0 1 1

Seq Scan on geoserver_acl g (cost=0.00..16.88 rows=3 width=64) (actual time=0.010..0.013 rows=1 loops=1)

  • Filter: (username = 'cmaoi'::text)
7. 26.041 1,052.439 ↓ 1,468.0 196,713 1

Append (cost=0.43..1,814.71 rows=134 width=260) (actual time=551.471..1,052.439 rows=196,713 loops=1)

8. 0.011 0.011 ↓ 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.011..0.011 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)))
9. 847.304 1,026.179 ↓ 1,548.9 196,713 1

Bitmap Heap Scan on contact_reports_p2019_06_12 cr_1 (cost=15.85..1,772.52 rows=127 width=260) (actual time=551.454..1,026.179 rows=196,713 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)))
10. 178.875 178.875 ↓ 1,836.4 833,742 1

Bitmap Index Scan on contact_reports_p2019_06_12_geopoint_idx (cost=0.00..15.82 rows=454 width=0) (actual time=178.875..178.875 rows=833,742 loops=1)

  • Index Cond: (geopoint && g.geometry)
11. 0.049 0.049 ↓ 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..5.51 rows=1 width=236) (actual time=0.049..0.049 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)))
12. 0.032 0.032 ↓ 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..5.51 rows=1 width=236) (actual time=0.032..0.032 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)))
13. 0.030 0.030 ↓ 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..5.51 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)))
14. 0.034 0.034 ↓ 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..5.51 rows=1 width=236) (actual time=0.033..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)))
15. 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..5.51 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)))
16. 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..5.51 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)))
17. 786.852 786.852 ↑ 1.0 1 196,713

Index Scan using pk_identities on identities i (cost=0.43..0.56 rows=1 width=202) (actual time=0.004..0.004 rows=1 loops=196,713)

  • Index Cond: (identity_id = cr.identity_id)
18. 0.015 0.040 ↓ 1.1 26 1

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

19. 0.025 0.025 ↓ 1.1 26 1

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