explain.depesz.com

PostgreSQL's explain analyze made readable

Result: caHY

Settings
# exclusive inclusive rows x rows loops node
1. 74,236.072 112,100.634 ↑ 93.4 142 1

Gather (cost=1,000.00..5,349,703.26 rows=13,262 width=246) (actual time=1,406.528..112,100.634 rows=142 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Functions: 135
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 22.717 ms, Inlining 300.810 ms, Optimization 590.951 ms, Emission 467.144 ms, Total 1381.622 ms
2. 0.004 37,864.562 ↑ 118.4 28 5 / 5

Parallel Append (cost=0.00..5,347,377.06 rows=3,314 width=246) (actual time=34,315.420..37,864.562 rows=28 loops=5)

3. 18.456 18.456 ↓ 0.0 0 2 / 5

Parallel Index Scan using ix_transition_user_id on transition (cost=0.57..5,845.68 rows=3,317 width=245) (actual time=46.139..46.139 rows=0 loops=2)

  • Index Cond: (user_id = 10,834,618)
  • Filter: ("timestamp" <= ((date_part('epoch'::text, CURRENT_TIMESTAMP) * '1000'::double precision))::bigint)
4. 0.004 37,846.102 ↑ 68.0 28 5 / 5

Parallel Append (cost=0.00..5,341,514.81 rows=1,904 width=246) (actual time=34,296.962..37,846.102 rows=28 loops=5)

5. 22,379.094 22,379.094 ↓ 0.0 0 1 / 5

Foreign Scan on transition_archive_2020_2 (cost=0.00..5,341,505.29 rows=3,634 width=247) (actual time=111,895.469..111,895.470 rows=0 loops=1)

  • Filter: ((user_id = 10,834,618) AND ("timestamp" <= ((date_part('epoch'::text, CURRENT_TIMESTAMP) * '1000'::double precision))::bigint))
  • Rows Removed by Filter: 168,728,074
  • CStore File: /var/lib/postgresql/data/cstore_fdw/22723540/171485917
  • CStore File Size: 9,907,740,804
6. 11,545.311 11,545.311 ↓ 0.0 0 1 / 5

Foreign Scan on transition_archive_2020_1 (cost=0.00..2,366,831.87 rows=1,585 width=247) (actual time=57,726.553..57,726.553 rows=0 loops=1)

  • Filter: ((user_id = 10,834,618) AND ("timestamp" <= ((date_part('epoch'::text, CURRENT_TIMESTAMP) * '1000'::double precision))::bigint))
  • Rows Removed by Filter: 78,392,634
  • CStore File: /var/lib/postgresql/data/cstore_fdw/22723540/171485913
  • CStore File Size: 3,590,758,218
7. 3,781.359 3,781.359 ↑ 12.1 142 1 / 5

Foreign Scan on transition_archive_2019 (cost=0.00..2,313,177.80 rows=1,718 width=256) (actual time=1,161.111..18,906.795 rows=142 loops=1)

  • Filter: ((user_id = 10,834,618) AND ("timestamp" <= ((date_part('epoch'::text, CURRENT_TIMESTAMP) * '1000'::double precision))::bigint))
  • Rows Removed by Filter: 28,197,589
  • CStore File: /var/lib/postgresql/data/cstore_fdw/22723540/171485910
  • CStore File Size: 2,493,544,283
8. 140.333 140.333 ↓ 0.0 0 1 / 5

Foreign Scan on transition_archive_2017_2018 (cost=0.00..1,819,473.93 rows=679 width=216) (actual time=701.663..701.663 rows=0 loops=1)

  • Filter: ((user_id = 10,834,618) AND ("timestamp" <= ((date_part('epoch'::text, CURRENT_TIMESTAMP) * '1000'::double precision))::bigint))
  • CStore File: /var/lib/postgresql/data/cstore_fdw/22723540/171485827
  • CStore File Size: 2,091,400,538
9. 0.000 0.000 ↓ 0.0 0 1 / 5

Foreign Scan on transition_archive_2020_4 (cost=0.00..0.95 rows=1 width=296) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((user_id = 10,834,618) AND ("timestamp" <= ((date_part('epoch'::text, CURRENT_TIMESTAMP) * '1000'::double precision))::bigint))
  • CStore File: /var/lib/postgresql/data/cstore_fdw/22723540/171485920
  • CStore File Size: 0
10. 0.000 0.000 ↓ 0.0 0 1 / 5

Foreign Scan on transition_archive_2021_1 (cost=0.00..0.95 rows=1 width=296) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((user_id = 10,834,618) AND ("timestamp" <= ((date_part('epoch'::text, CURRENT_TIMESTAMP) * '1000'::double precision))::bigint))
  • CStore File: /var/lib/postgresql/data/cstore_fdw/22723540/171485968
  • CStore File Size: 0
11. 0.000 0.000 ↓ 0.0 0 1 / 5

Foreign Scan on transition_archive_2021_2 (cost=0.00..0.95 rows=1 width=296) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((user_id = 10,834,618) AND ("timestamp" <= ((date_part('epoch'::text, CURRENT_TIMESTAMP) * '1000'::double precision))::bigint))
  • CStore File: /var/lib/postgresql/data/cstore_fdw/22723540/171485971
  • CStore File Size: 0
12. 0.000 0.000 ↓ 0.0 0 1 / 5

Foreign Scan on transition_archive_2021_3 (cost=0.00..0.95 rows=1 width=296) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((user_id = 10,834,618) AND ("timestamp" <= ((date_part('epoch'::text, CURRENT_TIMESTAMP) * '1000'::double precision))::bigint))
  • CStore File: /var/lib/postgresql/data/cstore_fdw/22723540/171485974
  • CStore File Size: 0
13. 0.000 0.000 ↓ 0.0 0 1 / 5

Foreign Scan on transition_archive_2021_4 (cost=0.00..0.95 rows=1 width=296) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((user_id = 10,834,618) AND ("timestamp" <= ((date_part('epoch'::text, CURRENT_TIMESTAMP) * '1000'::double precision))::bigint))
  • CStore File: /var/lib/postgresql/data/cstore_fdw/22723540/171485977
  • CStore File Size: 0
14. 0.000 0.000 ↓ 0.0 0 1 / 5

Foreign Scan on transition_archive_2020_3 (cost=0.00..0.93 rows=1 width=296) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: ((user_id = 10,834,618) AND ("timestamp" <= ((date_part('epoch'::text, CURRENT_TIMESTAMP) * '1000'::double precision))::bigint))
  • CStore File: /var/lib/postgresql/data/cstore_fdw/22723540/171694478
  • CStore File Size: 0
15. 0.000 0.000 ↓ 0.0 0 1 / 5

Foreign Scan on transition_archive_def (cost=0.00..0.93 rows=1 width=296) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((user_id = 10,834,618) AND ("timestamp" <= ((date_part('epoch'::text, CURRENT_TIMESTAMP) * '1000'::double precision))::bigint))
  • CStore File: /var/lib/postgresql/data/cstore_fdw/22723540/171694482
  • CStore File Size: 0
Planning time : 1.333 ms
Execution time : 112,140.493 ms