explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XjYJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 20,411.155 ↓ 0.0 0 1

Limit (cost=1,930,862.64..1,930,902.76 rows=10 width=1,034) (actual time=20,411.155..20,411.155 rows=0 loops=1)

2. 0.000 20,411.154 ↓ 0.0 0 1

Subquery Scan on x (cost=1,930,862.64..1,930,902.76 rows=10 width=1,034) (actual time=20,411.154..20,411.154 rows=0 loops=1)

  • Filter: ((x.pr = '0'::double precision) OR (x.pr = '1'::double precision))
3. 0.002 20,411.154 ↓ 0.0 0 1

WindowAgg (cost=1,930,862.64..1,930,887.72 rows=1,003 width=1,003) (actual time=20,411.154..20,411.154 rows=0 loops=1)

4. 0.000 20,411.152 ↓ 0.0 0 1

Sort (cost=1,930,862.64..1,930,865.15 rows=1,003 width=973) (actual time=20,411.152..20,411.152 rows=0 loops=1)

  • Sort Key: esma_firds.isin, esma_firds.mic, esma_firds.short_name, esma_firds.droit_reference_date
  • Sort Method: quicksort Memory: 25kB
5. 35.249 20,412.386 ↓ 0.0 0 1

Gather (cost=1,000.00..1,930,812.64 rows=1,003 width=973) (actual time=20,411.143..20,412.386 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 20,377.137 20,377.137 ↓ 0.0 0 3

Parallel Seq Scan on esma_firds (cost=0.00..1,929,712.34 rows=418 width=973) (actual time=20,377.137..20,377.137 rows=0 loops=3)

  • Filter: ((droit_reference_date_to <= '2019-08-08'::date) AND (droit_reference_date > '2019-07-05'::date) AND ((short_name)::text ~~ 'XXXARGENT%'::text))
  • Rows Removed by Filter: 13075902
Planning time : 1.032 ms
Execution time : 20,412.471 ms