explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rDqn

Settings
# exclusive inclusive rows x rows loops node
1. 33,634.940 34,191.349 ↑ 3.4 29 1

GroupAggregate (cost=96,039.18..96,140.51 rows=100 width=44) (actual time=552.246..34,191.349 rows=29 loops=1)

  • Group Key: g.workunit_internal_id, g.color_id
2. 40.445 556.409 ↓ 6.2 60,049 1

Sort (cost=96,039.18..96,063.57 rows=9,758 width=290) (actual time=544.344..556.409 rows=60,049 loops=1)

  • Sort Key: g.workunit_internal_id, g.color_id
  • Sort Method: external merge Disk: 17,288kB
3. 22.800 515.964 ↓ 6.2 60,049 1

Gather (cost=77,000.88..95,392.59 rows=9,758 width=290) (actual time=496.793..515.964 rows=60,049 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 5.450 493.164 ↓ 4.9 20,016 3 / 3

Parallel Hash Join (cost=76,000.88..93,416.79 rows=4,066 width=290) (actual time=479.308..493.164 rows=20,016 loops=3)

  • Hash Cond: ((gs.geoshape_geoid)::text = (z.zip_code)::text)
5. 8.569 8.569 ↑ 1.3 10,239 3 / 3

Parallel Seq Scan on geoshape gs (cost=0.00..17,350.98 rows=12,799 width=284) (actual time=0.006..8.569 rows=10,239 loops=3)

  • Filter: ((start_date <= '2020-01-01'::date) AND (end_date > '2020-01-01'::date) AND (start_date <= '2020-01-01'::date) AND (end_date > '2020-01-01'::date) AND (end_date > '2020-01-01'::date))
6. 137.784 479.145 ↓ 4.9 26,957 3 / 3

Parallel Hash (cost=75,931.70..75,931.70 rows=5,534 width=18) (actual time=479.144..479.145 rows=26,957 loops=3)

  • Buckets: 131,072 (originally 16384) Batches: 1 (originally 1) Memory Usage: 6,400kB
7. 5.945 341.361 ↓ 4.9 26,957 3 / 3

Nested Loop (cost=1,044.43..75,931.70 rows=5,534 width=18) (actual time=268.861..341.361 rows=26,957 loops=3)

8. 58.208 281.501 ↓ 4.9 26,957 3 / 3

Hash Join (cost=1,044.14..74,126.39 rows=5,534 width=20) (actual time=268.837..281.501 rows=26,957 loops=3)

  • Hash Cond: (za_6.workunit_internal_id = g.workunit_internal_id)
9. 62.411 220.339 ↑ 1.3 887,534 3 / 3

Parallel Append (cost=0.15..68,866.49 rows=1,109,487 width=16) (actual time=0.064..220.339 rows=887,534 loops=3)

10. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_42904_zip_internal_id_start_date_e_idx6 on zip_alignment_partition_429045333_temp za_6 (cost=0.15..14.16 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
11. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_42904_zip_internal_id_start_date_e_idx8 on zip_alignment_partition_429045335_temp za_8 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
12. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_42904_zip_internal_id_start_date_e_idx9 on zip_alignment_partition_429045336_temp za_9 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
13. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx10 on zip_alignment_partition_429045337_temp za_10 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
14. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx11 on zip_alignment_partition_429045338_temp za_11 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
15. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx16 on zip_alignment_partition_429045343_temp za_16 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
16. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx17 on zip_alignment_partition_429045344_temp za_17 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
17. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx18 on zip_alignment_partition_429045345_temp za_18 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
18. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx20 on zip_alignment_partition_429045347_temp za_20 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
19. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx25 on zip_alignment_partition_429045352_temp za_25 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
20. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx27 on zip_alignment_partition_429045354_temp za_27 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
21. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx28 on zip_alignment_partition_429045355_temp za_28 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
22. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx29 on zip_alignment_partition_429045356_temp za_29 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
23. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx30 on zip_alignment_partition_429045357_temp za_30 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
24. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx31 on zip_alignment_partition_429045358_temp za_31 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
25. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx32 on zip_alignment_partition_429045359_temp za_32 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
26. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx34 on zip_alignment_partition_429045361_temp za_34 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
27. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx37 on zip_alignment_partition_429045364_temp za_37 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
28. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx42 on zip_alignment_partition_429045369_temp za_42 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
29. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx44 on zip_alignment_partition_429045371_temp za_44 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
30. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx45 on zip_alignment_partition_429045372_temp za_45 (cost=0.15..14.16 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
31. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx46 on zip_alignment_partition_429045373_temp za_46 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
32. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx52 on zip_alignment_partition_429045379_temp za_52 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
33. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx54 on zip_alignment_partition_429045381_temp za_54 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
34. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx57 on zip_alignment_partition_429045384_temp za_57 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
35. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx63 on zip_alignment_partition_429045390_temp za_63 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
36. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx65 on zip_alignment_partition_429045392_temp za_65 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
37. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx66 on zip_alignment_partition_429045393_temp za_66 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
38. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx67 on zip_alignment_partition_429045394_temp za_67 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
39. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx68 on zip_alignment_partition_429045395_temp za_68 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
40. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx69 on zip_alignment_partition_429045396_temp za_69 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
41. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx70 on zip_alignment_partition_429045397_temp za_70 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
42. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx71 on zip_alignment_partition_429045398_temp za_71 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
43. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx72 on zip_alignment_partition_429045399_temp za_72 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
44. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx73 on zip_alignment_partition_429045400_temp za_73 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
45. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx74 on zip_alignment_partition_429045401_temp za_74 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
46. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx75 on zip_alignment_partition_429045402_temp za_75 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
47. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx76 on zip_alignment_partition_429045403_temp za_76 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
48. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx77 on zip_alignment_partition_429045404_temp za_77 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
49. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx78 on zip_alignment_partition_429045405_temp za_78 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
50. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx79 on zip_alignment_partition_429045406_temp za_79 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
51. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx80 on zip_alignment_partition_429045407_temp za_80 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
52. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx87 on zip_alignment_partition_429045414_temp za_87 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
53. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx89 on zip_alignment_partition_429045416_temp za_89 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
54. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx90 on zip_alignment_partition_429045417_temp za_90 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
55. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx91 on zip_alignment_partition_429045418_temp za_91 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
56. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx92 on zip_alignment_partition_429045419_temp za_92 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
57. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx97 on zip_alignment_partition_429045424_temp za_97 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
58. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx98 on zip_alignment_partition_429045425_temp za_98 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
59. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date_e_idx99 on zip_alignment_partition_429045426_temp za_99 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
60. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date__idx101 on zip_alignment_partition_429045428_temp za_101 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
61. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date__idx106 on zip_alignment_partition_429045433_temp za_106 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
62. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date__idx108 on zip_alignment_partition_429045435_temp za_108 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
63. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date__idx109 on zip_alignment_partition_429045436_temp za_109 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
64. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date__idx110 on zip_alignment_partition_429045437_temp za_110 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
65. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date__idx111 on zip_alignment_partition_429045438_temp za_111 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
66. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date__idx112 on zip_alignment_partition_429045439_temp za_112 (cost=0.15..14.16 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
67. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date__idx113 on zip_alignment_partition_429045440_temp za_113 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
68. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date__idx115 on zip_alignment_partition_429045442_temp za_115 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
69. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date__idx118 on zip_alignment_partition_429045445_temp za_118 (cost=0.15..14.16 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
70. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using zip_alignment_partition_4290_zip_internal_id_start_date__idx120 on zip_alignment_partition_429045447_temp za_120 (cost=0.15..14.16 rows=1 width=16) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
71. 4.855 4.855 ↓ 1.7 81,581 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045391_temp za_64 (cost=0.00..2,025.83 rows=47,989 width=16) (actual time=0.007..14.564 rows=81,581 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
72. 4.880 4.880 ↓ 1.7 82,018 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045349_temp za_22 (cost=0.00..2,006.69 rows=48,246 width=16) (actual time=0.006..14.639 rows=82,018 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
73. 4.845 4.845 ↓ 1.7 82,018 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045375_temp za_48 (cost=0.00..2,005.69 rows=48,246 width=16) (actual time=0.004..14.534 rows=82,018 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
74. 4.838 4.838 ↓ 1.7 82,018 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045348_temp za_21 (cost=0.00..2,004.69 rows=48,246 width=16) (actual time=0.004..14.514 rows=82,018 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
75. 5.531 5.531 ↑ 1.8 26,957 3 / 3

Parallel Seq Scan on zip_alignment_partition_429045377_temp za_50 (cost=0.00..1,977.58 rows=47,572 width=16) (actual time=0.022..5.531 rows=26,957 loops=3)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
76. 4.830 4.830 ↓ 1.7 82,018 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045341_temp za_14 (cost=0.00..1,968.69 rows=48,246 width=16) (actual time=0.004..14.491 rows=82,018 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
77. 4.810 4.810 ↓ 1.7 81,862 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045342_temp za_15 (cost=0.00..1,962.31 rows=48,154 width=16) (actual time=0.006..14.430 rows=81,862 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
78. 4.643 4.643 ↓ 1.7 78,764 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045380_temp za_53 (cost=0.00..1,883.98 rows=46,332 width=16) (actual time=0.004..13.929 rows=78,764 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
79. 4.565 4.565 ↓ 1.7 78,033 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045360_temp za_33 (cost=0.00..1,828.53 rows=45,902 width=16) (actual time=0.004..13.696 rows=78,033 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
80. 4.501 4.501 ↓ 1.7 76,559 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045383_temp za_56 (cost=0.00..1,812.52 rows=45,035 width=16) (actual time=0.003..13.504 rows=76,559 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
81. 4.481 4.481 ↓ 1.7 76,730 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045382_temp za_55 (cost=0.00..1,801.03 rows=45,135 width=16) (actual time=0.004..13.444 rows=76,730 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
82. 3.845 3.845 ↓ 1.7 65,164 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045340_temp za_13 (cost=0.00..1,505.98 rows=38,332 width=16) (actual time=0.004..11.534 rows=65,164 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
83. 3.241 3.241 ↓ 1.7 55,455 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045387_temp za_60 (cost=0.00..1,282.31 rows=32,621 width=16) (actual time=0.004..9.724 rows=55,455 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
84. 3.060 3.060 ↓ 1.7 50,319 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045378_temp za_51 (cost=0.00..1,162.99 rows=29,599 width=16) (actual time=0.002..9.179 rows=50,319 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
85. 2.805 2.805 ↓ 1.7 48,214 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045388_temp za_61 (cost=0.00..1,114.42 rows=28,361 width=16) (actual time=0.004..8.414 rows=48,214 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
86. 2.796 2.796 ↓ 1.7 47,515 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045339_temp za_12 (cost=0.00..1,098.25 rows=27,950 width=16) (actual time=0.004..8.387 rows=47,515 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
87. 2.734 2.734 ↓ 1.7 45,808 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045386_temp za_59 (cost=0.00..1,059.19 rows=26,946 width=16) (actual time=0.003..8.203 rows=45,808 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
88. 2.513 2.513 ↓ 1.7 43,286 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045332_temp za_5 (cost=0.00..1,000.94 rows=25,462 width=16) (actual time=0.004..7.540 rows=43,286 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
89. 2.592 2.592 ↓ 1.7 42,258 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045376_temp za_49 (cost=0.00..994.86 rows=24,858 width=16) (actual time=0.003..7.775 rows=42,258 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
90. 3.361 3.361 ↓ 1.7 42,297 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045327_temp za (cost=0.00..978.21 rows=24,881 width=16) (actual time=0.003..10.084 rows=42,297 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
91. 2.612 2.612 ↓ 1.7 42,171 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045328_temp za_1 (cost=0.00..975.10 rows=24,806 width=16) (actual time=0.004..7.837 rows=42,171 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
92. 2.444 2.444 ↑ 1.2 21,064 2 / 3

Parallel Seq Scan on zip_alignment_partition_429045363_temp za_36 (cost=0.00..973.72 rows=24,781 width=16) (actual time=0.003..3.666 rows=21,064 loops=2)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
93. 2.416 2.416 ↓ 1.7 41,285 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045329_temp za_2 (cost=0.00..954.28 rows=24,285 width=16) (actual time=0.006..7.249 rows=41,285 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
94. 2.503 2.503 ↓ 1.7 41,186 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045334_temp za_7 (cost=0.00..952.41 rows=24,227 width=16) (actual time=0.005..7.510 rows=41,186 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
95. 2.392 2.392 ↓ 1.7 41,186 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045415_temp za_88 (cost=0.00..952.41 rows=24,227 width=16) (actual time=0.003..7.176 rows=41,186 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
96. 2.404 2.404 ↓ 1.7 41,013 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045362_temp za_35 (cost=0.00..947.88 rows=24,125 width=16) (actual time=0.004..7.213 rows=41,013 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
97. 2.380 2.380 ↓ 1.7 41,013 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045441_temp za_114 (cost=0.00..947.88 rows=24,125 width=16) (actual time=0.003..7.141 rows=41,013 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
98. 2.377 2.377 ↓ 1.7 41,013 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045443_temp za_116 (cost=0.00..947.88 rows=24,125 width=16) (actual time=0.004..7.132 rows=41,013 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
99. 2.427 2.427 ↓ 1.7 41,013 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045444_temp za_117 (cost=0.00..947.88 rows=24,125 width=16) (actual time=0.005..7.280 rows=41,013 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
100. 2.370 2.370 ↓ 1.7 41,012 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045350_temp za_23 (cost=0.00..947.87 rows=24,125 width=16) (actual time=0.005..7.110 rows=41,012 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
101. 2.374 2.374 ↓ 1.7 41,012 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045351_temp za_24 (cost=0.00..947.87 rows=24,125 width=16) (actual time=0.005..7.123 rows=41,012 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
102. 2.375 2.375 ↓ 1.7 41,012 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045353_temp za_26 (cost=0.00..947.87 rows=24,125 width=16) (actual time=0.005..7.125 rows=41,012 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
103. 2.374 2.374 ↓ 1.7 41,012 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045408_temp za_81 (cost=0.00..947.87 rows=24,125 width=16) (actual time=0.004..7.121 rows=41,012 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
104. 2.434 2.434 ↓ 1.7 41,012 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045409_temp za_82 (cost=0.00..947.87 rows=24,125 width=16) (actual time=0.004..7.302 rows=41,012 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
105. 2.366 2.366 ↓ 1.7 41,012 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045410_temp za_83 (cost=0.00..947.87 rows=24,125 width=16) (actual time=0.004..7.097 rows=41,012 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
106. 2.368 2.368 ↓ 1.7 41,012 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045431_temp za_104 (cost=0.00..947.87 rows=24,125 width=16) (actual time=0.003..7.103 rows=41,012 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
107. 2.396 2.396 ↓ 1.7 41,012 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045432_temp za_105 (cost=0.00..947.87 rows=24,125 width=16) (actual time=0.004..7.187 rows=41,012 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
108. 2.361 2.361 ↓ 1.7 41,012 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045434_temp za_107 (cost=0.00..947.87 rows=24,125 width=16) (actual time=0.004..7.084 rows=41,012 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
109. 2.363 2.363 ↓ 1.7 41,009 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045330_temp za_3 (cost=0.00..947.84 rows=24,123 width=16) (actual time=0.004..7.088 rows=41,009 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
110. 2.373 2.373 ↓ 1.7 41,009 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045331_temp za_4 (cost=0.00..947.84 rows=24,123 width=16) (actual time=0.003..7.118 rows=41,009 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
111. 2.377 2.377 ↓ 1.7 41,009 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045346_temp za_19 (cost=0.00..947.84 rows=24,123 width=16) (actual time=0.003..7.131 rows=41,009 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
112. 2.368 2.368 ↓ 1.7 41,009 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045411_temp za_84 (cost=0.00..947.84 rows=24,123 width=16) (actual time=0.004..7.103 rows=41,009 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
113. 2.364 2.364 ↓ 1.7 41,009 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045412_temp za_85 (cost=0.00..947.84 rows=24,123 width=16) (actual time=0.004..7.093 rows=41,009 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
114. 2.379 2.379 ↓ 1.7 41,009 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045420_temp za_93 (cost=0.00..947.84 rows=24,123 width=16) (actual time=0.004..7.137 rows=41,009 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
115. 2.367 2.367 ↓ 1.7 41,009 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045421_temp za_94 (cost=0.00..947.84 rows=24,123 width=16) (actual time=0.004..7.101 rows=41,009 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
116. 2.386 2.386 ↓ 1.7 41,009 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045422_temp za_95 (cost=0.00..947.84 rows=24,123 width=16) (actual time=0.004..7.157 rows=41,009 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
117. 2.373 2.373 ↓ 1.7 41,009 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045423_temp za_96 (cost=0.00..947.84 rows=24,123 width=16) (actual time=0.004..7.118 rows=41,009 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
118. 2.376 2.376 ↓ 1.7 41,009 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045427_temp za_100 (cost=0.00..947.84 rows=24,123 width=16) (actual time=0.004..7.128 rows=41,009 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
119. 2.381 2.381 ↓ 1.7 41,009 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045429_temp za_102 (cost=0.00..947.84 rows=24,123 width=16) (actual time=0.004..7.143 rows=41,009 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
120. 2.377 2.377 ↓ 1.7 41,009 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045430_temp za_103 (cost=0.00..947.84 rows=24,123 width=16) (actual time=0.004..7.132 rows=41,009 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
121. 2.437 2.437 ↓ 1.7 40,994 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045385_temp za_58 (cost=0.00..947.71 rows=24,114 width=16) (actual time=0.003..7.310 rows=40,994 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
122. 2.385 2.385 ↓ 1.7 40,989 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045413_temp za_86 (cost=0.00..947.67 rows=24,111 width=16) (actual time=0.004..7.155 rows=40,989 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
123. 1.039 1.039 ↓ 1.7 17,645 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045389_temp za_62 (cost=0.00..408.69 rows=10,379 width=16) (actual time=0.003..3.118 rows=17,645 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
124. 0.356 0.356 ↓ 1.7 5,986 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045374_temp za_47 (cost=0.00..146.82 rows=3,521 width=16) (actual time=0.004..1.069 rows=5,986 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
125. 0.020 0.020 ↓ 1.7 174 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045365_temp za_38 (cost=0.00..4.54 rows=102 width=16) (actual time=0.003..0.061 rows=174 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
126. 0.011 0.011 ↓ 1.7 174 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045366_temp za_39 (cost=0.00..4.54 rows=102 width=16) (actual time=0.003..0.032 rows=174 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
127. 0.011 0.011 ↓ 1.7 173 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045370_temp za_43 (cost=0.00..4.53 rows=102 width=16) (actual time=0.004..0.032 rows=173 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
128. 0.011 0.011 ↓ 1.7 171 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045367_temp za_40 (cost=0.00..4.51 rows=101 width=16) (actual time=0.004..0.032 rows=171 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
129. 0.010 0.010 ↓ 1.7 160 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045446_temp za_119 (cost=0.00..4.41 rows=94 width=16) (actual time=0.004..0.031 rows=160 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
130. 0.011 0.011 ↓ 1.7 123 1 / 3

Parallel Seq Scan on zip_alignment_partition_429045368_temp za_41 (cost=0.00..3.09 rows=72 width=16) (actual time=0.008..0.032 rows=123 loops=1)

  • Filter: ((start_date <= '2020-01-01'::date) AND (request_id = 0))
131. 0.021 2.954 ↑ 1.0 100 3 / 3

Hash (cost=1,042.74..1,042.74 rows=100 width=12) (actual time=2.953..2.954 rows=100 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
132. 2.933 2.933 ↑ 1.0 100 3 / 3

Seq Scan on workunit g (cost=0.00..1,042.74 rows=100 width=12) (actual time=0.285..2.933 rows=100 loops=3)

  • Filter: ((level_internal_id = '429045241'::bigint) AND (request_id = 0))
  • Rows Removed by Filter: 19,949
133. 53.915 53.915 ↑ 1.0 1 80,872 / 3

Index Scan using zip_zip_internal_id_idx on zip z (cost=0.29..0.32 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=80,872)

  • Index Cond: (zip_internal_id = za_6.zip_internal_id)
  • Filter: ((start_date <= '2020-01-01'::date) AND (end_date > '2020-01-01'::date) AND (request_id = 0))