explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W0q3

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 1,369.925 ↑ 1.0 100 1

Limit (cost=69,635.53..69,635.78 rows=100 width=74) (actual time=1,369.910..1,369.925 rows=100 loops=1)

2. 73.238 1,369.914 ↑ 4,294.7 100 1

Sort (cost=69,635.53..70,709.20 rows=429,467 width=74) (actual time=1,369.909..1,369.914 rows=100 loops=1)

  • Sort Key: fr.valid_from DESC
  • Sort Method: top-N heapsort Memory: 48kB
3. 373.721 1,296.676 ↓ 1.1 454,405 1

HashAggregate (cost=48,926.94..53,221.61 rows=429,467 width=74) (actual time=1,186.549..1,296.676 rows=454,405 loops=1)

  • Group Key: fr.id
4. 559.537 922.955 ↓ 2.0 858,517 1

Hash Join (cost=25,318.10..46,779.61 rows=429,467 width=74) (actual time=287.427..922.955 rows=858,517 loops=1)

  • Hash Cond: ((factual_report_subscore.factual_report_id)::text = (fr.id)::text)
  • Join Filter: (SubPlan 1)
5. 77.325 77.325 ↑ 1.0 858,849 1

Seq Scan on factual_report_subscore (cost=0.00..19,206.69 rows=858,969 width=33) (actual time=0.013..77.325 rows=858,849 loops=1)

6. 150.705 286.093 ↓ 1.0 454,405 1

Hash (cost=19,638.22..19,638.22 rows=454,390 width=66) (actual time=286.092..286.093 rows=454,405 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 50247kB
7. 135.388 135.388 ↓ 1.0 454,405 1

Seq Scan on factual_report fr (cost=0.00..19,638.22 rows=454,390 width=66) (actual time=0.014..135.388 rows=454,405 loops=1)

  • Filter: ((epicenter_lat >= '-56.2999999999999972'::double precision) AND (epicenter_lat <= '72.0999999999999943'::double precision) AND (epicenter_long >= '-179'::double precision) AND (epicenter_long <= '179'::double precision) AND (valid_to >= '2003-01-01 08:57:01'::timestamp without time zone) AND (valid_from <= '2019-10-22 09:27:01'::timestamp without time zone))
8.          

SubPlan (for Hash Join)

9. 0.000 0.000 ↑ 1.0 1 858,517

Result (cost=0.00..0.01 rows=1 width=66) (actual time=0.000..0.000 rows=1 loops=858,517)

  • One-Time Filter: ((fr.organization_id)::text = '59087ebe6acef17ef317c5c8'::text)
Planning time : 1.318 ms
Execution time : 1,379.597 ms