explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ru1Q

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.199 ↑ 1.0 5 1

Limit (cost=0.86..37.44 rows=5 width=462) (actual time=0.104..0.199 rows=5 loops=1)

2. 0.001 0.194 ↑ 91,858.8 5 1

Limit (cost=0.86..3,355,297.66 rows=459,294 width=462) (actual time=0.103..0.194 rows=5 loops=1)

3. 0.026 0.193 ↑ 91,858.8 5 1

Nested Loop (cost=0.86..3,355,297.66 rows=459,294 width=462) (actual time=0.102..0.193 rows=5 loops=1)

4. 0.012 0.117 ↑ 91,858.8 5 1

Nested Loop (cost=0.44..550,484.18 rows=459,294 width=273) (actual time=0.079..0.117 rows=5 loops=1)

  • Join Filter: (cr.provider_id = p.provider_id)
  • Rows Removed by Join Filter: 84
5. 0.024 0.085 ↑ 91,858.8 5 1

Nested Loop (cost=0.44..398,341.66 rows=459,294 width=254) (actual time=0.061..0.085 rows=5 loops=1)

  • Join Filter: ((cr.geopoint && g.geometry) AND CASE WHEN (g.providers IS NOT NULL) THEN (cr.provider_id = ANY (g.providers)) ELSE true END)
  • Rows Removed by Join Filter: 13
6. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on geoserver_acl g (cost=0.00..1.04 rows=1 width=175) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (username = 'cmaoi'::text)
  • Rows Removed by Filter: 2
7. 0.002 0.050 ↑ 229,553.6 18 1

Append (cost=0.44..295,041.50 rows=4,131,965 width=254) (actual time=0.010..0.050 rows=18 loops=1)

8. 0.012 0.012 ↑ 7,303.0 2 1

Index Scan using contact_reports_p2019_09_30_received_date_time_idx on contact_reports_p2019_09_30 cr (cost=0.44..975.04 rows=14,606 width=253) (actual time=0.010..0.012 rows=2 loops=1)

  • Index Cond: (received_date_time >= '2019-10-01 10:27:49.84454'::timestamp without time zone)
9. 0.036 0.036 ↑ 257,303.8 16 1

Index Scan using contact_reports_p2019_10_01_received_date_time_idx on contact_reports_p2019_10_01 cr_1 (cost=0.43..273,327.88 rows=4,116,861 width=254) (actual time=0.023..0.036 rows=16 loops=1)

  • Index Cond: (received_date_time >= '2019-10-01 10:27:49.84454'::timestamp without time zone)
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on contact_reports_p2019_10_02 cr_2 (cost=0.00..13.12 rows=83 width=236) (never executed)

  • Filter: (received_date_time >= '2019-10-01 10:27:49.84454'::timestamp without time zone)
11. 0.000 0.000 ↓ 0.0 0

Seq Scan on contact_reports_p2019_10_03 cr_3 (cost=0.00..13.12 rows=83 width=236) (never executed)

  • Filter: (received_date_time >= '2019-10-01 10:27:49.84454'::timestamp without time zone)
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on contact_reports_p2019_10_04 cr_4 (cost=0.00..13.12 rows=83 width=236) (never executed)

  • Filter: (received_date_time >= '2019-10-01 10:27:49.84454'::timestamp without time zone)
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on contact_reports_p2019_10_05 cr_5 (cost=0.00..13.12 rows=83 width=236) (never executed)

  • Filter: (received_date_time >= '2019-10-01 10:27:49.84454'::timestamp without time zone)
14. 0.000 0.000 ↓ 0.0 0

Seq Scan on contact_reports_p2019_10_06 cr_6 (cost=0.00..13.12 rows=83 width=236) (never executed)

  • Filter: (received_date_time >= '2019-10-01 10:27:49.84454'::timestamp without time zone)
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on contact_reports_default cr_7 (cost=0.00..13.12 rows=83 width=236) (never executed)

  • Filter: (received_date_time >= '2019-10-01 10:27:49.84454'::timestamp without time zone)
16. 0.013 0.020 ↑ 1.3 18 5

Materialize (cost=0.00..1.34 rows=23 width=23) (actual time=0.001..0.004 rows=18 loops=5)

17. 0.007 0.007 ↑ 1.2 19 1

Seq Scan on providers p (cost=0.00..1.23 rows=23 width=23) (actual time=0.004..0.007 rows=19 loops=1)

18. 0.050 0.050 ↑ 1.0 1 5

Index Scan using pk_identities on identities i (cost=0.43..6.09 rows=1 width=179) (actual time=0.010..0.010 rows=1 loops=5)

  • Index Cond: (identity_id = cr.identity_id)
Planning time : 9.046 ms
Execution time : 0.344 ms