explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cF30

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 1.840 ↑ 1.0 50 1

Limit (cost=0.42..1,089.53 rows=50 width=2,656) (actual time=0.883..1.840 rows=50 loops=1)

2. 0.694 1.832 ↑ 324.1 50 1

Nested Loop (cost=0.42..352,937.19 rows=16,203 width=2,656) (actual time=0.882..1.832 rows=50 loops=1)

  • Join Filter: ((i.collection)::text = (c.id)::text)
3. 0.938 1.138 ↑ 324.1 50 1

Index Scan using idx_cloud_cover on items i (cost=0.42..311,861.56 rows=16,203 width=1,479) (actual time=0.840..1.138 rows=50 loops=1)

  • Index Cond: ((((properties -> 'eo:cloud_cover'::text))::numeric >= '26'::numeric) AND (((properties -> 'eo:cloud_cover'::text))::numeric <= '40'::numeric))
  • Filter: ((datetime > '2017-04-05 00:00:00'::timestamp without time zone) AND (datetime < '2018-05-02 23:59:00'::timestamp without time zone))
  • Rows Removed by Filter: 613
4.          

SubPlan (for Index Scan)

5. 0.050 0.200 ↑ 1.0 1 50

Result (cost=2.04..2.05 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=50)

6.          

Initplan (for Result)

7. 0.050 0.100 ↑ 1.0 1 50

Limit (cost=0.00..1.02 rows=1 width=32) (actual time=0.001..0.002 rows=1 loops=50)

8. 0.050 0.050 ↑ 1.0 1 50

Seq Scan on apiurls (cost=0.00..1.02 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=50)

9. 0.050 0.050 ↑ 1.0 1 50

Limit (cost=0.00..1.01 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=50)

10. 0.000 0.000 ↑ 1.0 1 50

Seq Scan on apiurls apiurls_1 (cost=0.00..1.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=50)

11. 0.000 0.000 ↑ 2.0 1 50

Materialize (cost=0.00..1.03 rows=2 width=1,127) (actual time=0.000..0.000 rows=1 loops=50)

12. 0.003 0.003 ↑ 2.0 1 1

Seq Scan on collections c (cost=0.00..1.02 rows=2 width=1,127) (actual time=0.003..0.003 rows=1 loops=1)