explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PEMK

Settings
# exclusive inclusive rows x rows loops node
1. 0.053 15,946.241 ↑ 526.8 190 1

Unique (cost=60,760.73..61,511.40 rows=100,089 width=12) (actual time=15,946.166..15,946.241 rows=190 loops=1)

2. 0.000 15,946.188 ↑ 526.8 190 1

Sort (cost=60,760.73..61,010.96 rows=100,089 width=12) (actual time=15,946.165..15,946.188 rows=190 loops=1)

  • Sort Key: agent_event_2019_03_01.id, (unnest(array_remove(ARRAY[CASE WHEN ((agent_event_2019_03_01.text_data ~~* '%сучара%'::text) OR (agent_event_2019_03_01.text_data ~~* '%хуйня%'::text) OR (agent_event_2019_03_01.text_data ~~* '%блят%'::text) OR (agent_event_2019_03_01.text_data ~~* '%бляд%'::text) OR (agent_event_2019_03_01.text_data ~~* '%пидарас%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ипись %'::text) OR (agent_event_2019_03_01.text_data ~~* '%изъеб%'::text) OR (agent_event_2019_03_01.text_data ~~* '%еблан%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебеный%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебущий%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебанашка%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебырь%'::text) OR (agent_event_2019_03_01.text_data ~~* '%хуище%'::text) OR (agent_event_2019_03_01.text_data ~~* '%гребан%'::text) OR (agent_event_2019_03_01.text_data ~~* '%уебище%'::text) OR (agent_event_2019_03_01.text_data ~~* '%уебан%'::text) OR (agent_event_2019_03_01.text_data ~~* '%феееб%'::text) OR (agent_event_2019_03_01.text_data ~~* '%6ляд%'::text) OR (agent_event_2019_03_01.text_data ~~* '%сцука%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебали%'::text) OR (agent_event_2019_03_01.text_data ~~* '%пестато%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебало%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебли%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебло%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебанут%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебут%'::text) OR (agent_event_2019_03_01.text_data ~~* '%заебу%'::text) OR (agent_event_2019_03_01.text_data ~~* '%выебу%'::text) OR (agent_event_2019_03_01.text_data ~~* '%хуйло%'::text) OR (agent_event_2019_03_01.text_data ~~* '%нехе%'::text) OR (agent_event_2019_03_01.text_data ~~* '%неху%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ниху%'::text) OR (agent_event_2019_03_01.text_data ~~* '%нихе%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ибанут%'::text) OR (agent_event_2019_03_01.text_data ~~* '%fuck%'::text) OR (agent_event_2019_03_01.text_data ~~* '%хули %'::text) OR (agent_event_2019_03_01.text_data ~~* '%хуля %'::text) OR (agent_event_2019_03_01.text_data ~~* '%хуе%'::text) OR (agent_event_2019_03_01.text_data ~~* '%хуё%'::text) OR (agent_event_2019_03_01.text_data ~~* '%мудл%'::text) OR (agent_event_2019_03_01.text_data ~~* '%хер %'::text) OR (agent_event_2019_03_01.text_data ~~* '%пидар%'::text) OR (agent_event_2019_03_01.text_data ~~* '%наху%'::text) OR (agent_event_2019_03_01.text_data ~~* '%педер%'::text) OR (agent_event_2019_03_01.text_data ~~* '%пидер%'::text) OR (agent_event_2019_03_01.text_data ~~* '%пидир%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ёбну%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебну%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебыр%'::text) OR (agent_event_2019_03_01.text_data ~~* '%заеб%'::text) OR (agent_event_2019_03_01.text_data ~~* '%заёб%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебен%'::text) OR (agent_event_2019_03_01.text_data ~~* '%блятc%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебли%'::text) OR (agent_event_2019_03_01.text_data ~~* '%аебли%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебло%'::text) OR (agent_event_2019_03_01.text_data ~~* '%заебло%'::text) OR (agent_event_2019_03_01.text_data ~~* '%переебло%'::text) OR (agent_event_2019_03_01.text_data ~~* '%отебло%'::text) OR (agent_event_2019_03_01.text_data ~~* '%отъебло%'::text) OR (agent_event_2019_03_01.text_data ~~* '%отьебло%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебеш%'::text) OR (agent_event_2019_03_01.text_data ~~* '%выеб%'::text) OR (agent_event_2019_03_01.text_data ~~* '%отъеб%'::text) OR (agent_event_2019_03_01.text_data ~~* '%отьеб%'::text) OR (agent_event_2019_03_01.text_data ~~* '%перееб%'::text) OR (agent_event_2019_03_01.text_data ~~* '%хуйла%'::text) OR (agent_event_2019_03_01.text_data ~~* '%заеб%'::text) OR (agent_event_2019_03_01.text_data ~~* '%хую%'::text) OR (agent_event_2019_03_01.text_data ~~* '%6ля%'::text) OR (agent_event_2019_03_01.text_data ~~* '%6ля%'::text) OR (agent_event_2019_03_01.text_data ~~* '%блЯ%'::text) OR (agent_event_2019_03_01.text_data ~~* '%бля%'::text) OR (agent_event_2019_03_01.text_data ~~* '%бля%'::text) OR (agent_event_2019_03_01.text_data ~~* '%хуило%'::text) OR (agent_event_2019_03_01.text_data ~~* '%хуюше%'::text) OR (agent_event_2019_03_01.text_data ~~* '%сука%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ъеб%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ъёб%'::text) OR (agent_event_2019_03_01.text_data ~~* '%бляд%'::text) OR (agent_event_2019_03_01.text_data ~~* '%блябу%'::text) OR (agent_event_2019_03_01.text_data ~~* '%бля бу%'::text) OR (agent_event_2019_03_01.text_data ~~* '%залупа%'::text) OR (agent_event_2019_03_01.text_data ~~* '%хера%'::text) OR (agent_event_2019_03_01.text_data ~~* '%пизжен%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ёпта%'::text) OR (agent_event_2019_03_01.text_data ~~* '%епта%'::text) OR (agent_event_2019_03_01.text_data ~~* '%пистапол%'::text) OR (agent_event_2019_03_01.text_data ~~* '%пизда%'::text) OR (agent_event_2019_03_01.text_data ~~* '%залупить%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебать%'::text) OR (agent_event_2019_03_01.text_data ~~* '%мудо%'::text) OR (agent_event_2019_03_01.text_data ~~* '%манда %'::text) OR (agent_event_2019_03_01.text_data ~~* '%мандавошка%'::text) OR (agent_event_2019_03_01.text_data ~~* '%мокрощелка%'::text) OR (agent_event_2019_03_01.text_data ~~* '%муда%'::text) OR (agent_event_2019_03_01.text_data ~~* '%муде%'::text) OR (agent_event_2019_03_01.text_data ~~* '%муди%'::text) OR (agent_event_2019_03_01.text_data ~~* '%мудн%'::text) OR (agent_event_2019_03_01.text_data ~~* '%мудо%'::text) OR (agent_event_2019_03_01.text_data ~~* '%пизд%'::text) OR (agent_event_2019_03_01.text_data ~~* '%хуе%'::text) OR (agent_event_2019_03_01.text_data ~~* '%похую%'::text) OR (agent_event_2019_03_01.text_data ~~* '%похуй%'::text) OR (agent_event_2019_03_01.text_data ~~* '%охуи%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ебля%'::text) OR (agent_event_2019_03_01.text_data ~~* '%пидорас%'::text) OR (agent_event_2019_03_01.text_data ~~* '%пидор%'::text) OR (agent_event_2019_03_01.text_data ~~* '%херн%'::text) OR (agent_event_2019_03_01.text_data ~~* '%щлюха%'::text) OR (agent_event_2019_03_01.text_data ~~* '%хуй%'::text) OR (agent_event_2019_03_01.text_data ~~* '%писдеш%'::text) OR (agent_event_2019_03_01.text_data ~~* '%писдит%'::text) OR (agent_event_2019_03_01.text_data ~~* '%писдиш%'::text) OR (agent_event_2019_03_01.text_data ~~* '%нехуй%'::text) OR (agent_event_2019_03_01.text_data ~~* '%ниибаца%'::text)) THEN 87 ELSE 0 END], 0)))
  • Sort Method: quicksort Memory: 33kB
3. 12.504 15,951.005 ↑ 526.8 190 1

Gather (cost=1,000.43..52,447.88 rows=100,089 width=12) (actual time=79.730..15,951.005 rows=190 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 15,832.148 15,938.501 ↑ 66,215.9 63 3

ProjectSet (cost=0.43..41,438.98 rows=4,171,600 width=12) (actual time=48.688..15,938.501 rows=63 loops=3)

5. 5.517 106.353 ↑ 1.3 33,317 3

Parallel Append (cost=0.43..8,066.18 rows=41,716 width=85) (actual time=16.121..106.353 rows=33,317 loops=3)

6. 0.066 0.066 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2019_03_01_c55bf703 on agent_event_2019_03_01 (cost=0.44..8.45 rows=1 width=161) (actual time=0.066..0.066 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
7. 0.028 0.028 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2018_06_01_49aa2178 on agent_event_2018_06_01 (cost=0.43..8.45 rows=1 width=89) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
8. 0.017 0.017 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2019_02_01_37d6c88d on agent_event_2019_02_01 (cost=0.43..8.45 rows=1 width=159) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
9. 0.022 0.022 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2019_04_01_e7d23fce on agent_event_2019_04_01 (cost=0.43..8.45 rows=1 width=167) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
10. 0.017 0.017 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2018_11_01_b1faba8e on agent_event_2018_11_01 (cost=0.43..8.45 rows=1 width=329) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
11. 0.019 0.019 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2018_12_01_606cfb84 on agent_event_2018_12_01 (cost=0.43..8.45 rows=1 width=199) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
12. 0.026 0.026 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2018_01_01_23be493a on agent_event_2018_01_01 (cost=0.43..8.45 rows=1 width=97) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
13. 0.014 0.014 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2018_10_01_9b6e5968 on agent_event_2018_10_01 (cost=0.43..8.45 rows=1 width=246) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
14. 0.014 0.014 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2018_02_01_2a0c57d8 on agent_event_2018_02_01 (cost=0.43..8.44 rows=1 width=67) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
15. 0.016 0.016 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2018_05_01_e47be59b on agent_event_2018_05_01 (cost=0.43..8.44 rows=1 width=100) (actual time=0.015..0.016 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
16. 0.028 0.028 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2018_09_01_c85b68f4 on agent_event_2018_09_01 (cost=0.43..8.44 rows=1 width=166) (actual time=0.027..0.028 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
17. 0.014 0.014 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2019_01_01_ac3eac13 on agent_event_2019_01_01 (cost=0.43..8.44 rows=1 width=142) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
18. 0.013 0.013 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2018_04_01_a02b7f12 on agent_event_2018_04_01 (cost=0.42..8.44 rows=1 width=91) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
19. 0.015 0.015 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2018_08_01_e2f4f27c on agent_event_2018_08_01 (cost=0.42..8.44 rows=1 width=150) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
20. 0.011 0.011 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2018_07_01_2a614462 on agent_event_2018_07_01 (cost=0.29..8.30 rows=1 width=181) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
21. 0.014 0.014 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2017_10_01_50d9ddf8 on agent_event_2017_10_01 (cost=0.14..8.16 rows=1 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
22. 0.006 0.006 ↓ 0.0 0 1

Parallel Index Scan using agent_event_2019_05_01_fd5fee9a on agent_event_2019_05_01 (cost=0.14..8.16 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
23. 0.012 0.012 ↓ 0.0 0 1

Parallel Index Scan using agent_event_default_a189e9b6 on agent_event_default (cost=0.14..8.16 rows=1 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((id > 8502696) AND (id < 8609797))
24. 100.459 100.459 ↑ 1.3 33,317 3

Parallel Seq Scan on agent_event_2017_11_01 (cost=0.00..7,286.23 rows=41,695 width=85) (actual time=15.993..100.459 rows=33,317 loops=3)

  • Filter: ((id > 8502696) AND (id < 8609797))
  • Rows Removed by Filter: 2908
25. 0.007 0.007 ↓ 0.0 0 1

Parallel Seq Scan on agent_event_1600_01_01 (cost=0.00..1.16 rows=1 width=34) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: ((id > 8502696) AND (id < 8609797))
  • Rows Removed by Filter: 18
26. 0.004 0.004 ↓ 0.0 0 1

Parallel Seq Scan on agent_event_2018_03_01 (cost=0.00..1.02 rows=1 width=176) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((id > 8502696) AND (id < 8609797))
  • Rows Removed by Filter: 2
27. 0.014 0.014 ↓ 0.0 0 1

Parallel Seq Scan on agent_event_2017_12_01 (cost=0.00..1.01 rows=1 width=9) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: ((id > 8502696) AND (id < 8609797))
  • Rows Removed by Filter: 1
Planning time : 5.889 ms
Execution time : 15,958.763 ms